I just want to have a single macro that finds everything.) My attempt so far doesn't update fields in text boxes inside figures.
Note that the macro makes sure that the options are set to force updating the fields and links when printing occurs, then it updates all the members of the Fields collection in the document.
If you, instead, wanted to update the fields at closing, you could use this macro: is your source for cost-effective Microsoft Word training.
The word doc has about 50 links to the same spreadsheet so it opens it 50 times.
To stop myself from going completely crazy, I have to open the spreadsheet first and then open the word doc.
(In theory updating fields can cause other fields to need updating, e.g.
a longer table of contents changes some page numbers in the main text. This includes updates of page numbers in '' tables (but would not add or remove entries). I have a word 2010 document that contains links to an excel 2010 spreadsheet.Every time I open the word document, it insists on opening the excel spreadsheet to update each and every link.(Microsoft Word is the most popular word processing software in the world.) This tip (654) applies to Microsoft Word 97, 2000, 2002, and 2003.You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Updating Automatic Links.I have never heard of locking fields - I just tried it and it seems to work very nicely. I can imagine someone opening this word doc months down the track and not understanding why the fields don't update.