Friday, March 2, 2012

How to Update an Excel Cell in Microsoft Word 2007

As you work with an Excel spreadsheet in a Microsoft Word 2007 document, you may find that the cells aren't updating. If you pasted the table into Word correctly, the cells should update whenever you update the original Excel file. If this feature isn't working, however, you'll need to remove the table you copied into Word and copy it again with the most up-to-date options. Afterward when you update the table in Excel 2007, it should update in Word 2007 as well.

Instructions

 1. Open Microsoft Word 2007. Click the Office button at the top of the screen and choose "Open." Navigate to where your Word document is stored and open it. 

2. Click on the original Microsoft Excel Worksheet Object in your Word document. Press "Delete" to remove it.
3. Open Microsoft Excel. Select the table or data you want to display in Microsoft Word 2007. Click the "Copy" button in the Home tab's Clipboard group.
4. Switch to Word 2007. Click the "Paste" button in Word's Clipboard group. Click the "Paste Options" button next to the pasted Excel table. Choose "Keep Source Formatting and Link to Excel" from the list. This may also be called "Match Destination Table Style and Link to Excel."
5. Update cells in the original Excel table. They will automatically update in the Word 2007 document as well.
//