How can I copy a table with “data bars” from Excel 2010 to Word 2010, retaining table properties instead of as a picture or PDF?

Linking a chart to a newsletter or report is an excellent example of how to use Microsoft Office effectively. Say someone corrected the data in the spreadsheet. The chart in Microsoft Excel will change. The chart that you linked with Paste Special in Word will update, too.

These same steps can be used to select a Range of data in Excel (including Conditional Formatting such as Data Bars) and Paste Special in Word.

Memo to self: When you Paste Special choose a Microsoft Excel Object to keep all of the original ...

Continue Reading →