Updating excel from a word file
Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.Click "OK." Tricia Goss' credits include Fitness Plus, Good News Tucson and Layover Magazine.There are two ways to program a spreadsheet to update automatically: every time the workbook is opened and at regular intervals that you determine.Make sure you are on the "Usage" tab of the "Connection Properties" dialog box.This is confusing enough, but my problem is that I can't even manually update in the case of two spreadsheets I maintain.I keep lots of different data that is updated from various websites and databases.If you are using Word to build a report that relies on Excel tables, you have a couple of ways to achieve it.One is to create links to the Excel file, which is OK if the file is not very large or calculation-intensive, and you don’t have too many bookmarks.
If you update the Excel sheet, it will not reflect the changes in the Word.
There are a couple of ways of doing it – called Linking to an object and Creating a new Excel inside Word.
Normally, most of us will not follow these two methods, but will go for copy paste method.
When I first link the chart into my word doc (which is how I format my reports I send in email), the chart updates ok. Why does updating happen automatically after I close excel in the original steps. What is unique about my 2 spreadsheets that even a manual update doesn't work?
But the next week when I update all my charts, nothing gets update in my Word document.