Updating excel from a word file

28-Apr-2020 13:32

There are basically two ways that you can accomplish this.The first way is to simply embed the Excel table or chart into Word and you will get a snapshot of the data at the time you embedded the chart.If you have already created a chart in Excel, you can embed and link it to your Word document.When you embed an Excel chart in Word, any updates you make to the original Excel chart will automatically update in your Word document, as long as the files remain in the same location.Each time you create a new report based on the template, it'll pull in the latest version of the chart.Follow these general steps: When you create a new document based on the template, Word warns you that the document contains links that may refer to other files (see Figure 9-14).This works fine, but it means that to make sure it's up to date, I need to paste in the chart about five seconds before I print the documentwhich feels more than a little tense.It sounds as though you'd do better to link the chart to your report template.

Copying the cell and clicking on Edit, Paste Special and selecting Microsoft Excel Worksheet Object and selecting Paste link didn’t work because the data wouldn’t line up properly. In Office 2007, Paste Special is under the Clipboard section of the Ribbon, or you could use the shortcut Ctrl Alt V, which will take you directly to the window displayed below.

The remaining steps are the same in both versions.)But with some experimenting, he discovered it can be done easily by copying the cell, going to Word, placing the cursor at the target insertion point, clicking on Edit, Paste Special and then selecting either Unformatted Unicode Text or just Unformatted Text (instead of Microsoft Office Excel Worksheet Object) and then clicking Paste link and OK (see screenshot below).

Now, when the cell value changes in the Excel spreadsheet, it will also update in the Word document the next time it is opened.

( Note: For this feature to work, ensure automatic updating is enabled in Word.

Go to Word Options, Advanced and scroll down to the General settings.

Copying the cell and clicking on Edit, Paste Special and selecting Microsoft Excel Worksheet Object and selecting Paste link didn’t work because the data wouldn’t line up properly. In Office 2007, Paste Special is under the Clipboard section of the Ribbon, or you could use the shortcut Ctrl Alt V, which will take you directly to the window displayed below.The remaining steps are the same in both versions.)But with some experimenting, he discovered it can be done easily by copying the cell, going to Word, placing the cursor at the target insertion point, clicking on Edit, Paste Special and then selecting either Unformatted Unicode Text or just Unformatted Text (instead of Microsoft Office Excel Worksheet Object) and then clicking Paste link and OK (see screenshot below).Now, when the cell value changes in the Excel spreadsheet, it will also update in the Word document the next time it is opened.( Note: For this feature to work, ensure automatic updating is enabled in Word.Go to Word Options, Advanced and scroll down to the General settings.Choose Tools » Options, click the Print tab, and check the "Update links" box.