Updating fields in excel dating in newport

To manually update a field, right-click it and choose Update Field, or select it and press F9.If neither of these methods works, check to make sure the field is not locked.The author had had the same issue — it took more than an hour for the fields to update for him too. I tried a few things (listed below), and eventually I found the culprit — it was a linked Excel chart that couldn’t be found.

updating fields in excel-83

Therefore, when Word tried to update the fields, it went looking for something that didn’t exist and got itself into an infinite loop of looking and looking.

Once I’d taken a screen capture of that chart (with the author’s permission) and inserted that into the document instead, the fields updated in just a few minutes, as they normally do for these client documents.

Try unlocking it by selecting the field and pressing Ctrl Shift F11.

Also examine the field’s code and make sure that the switch is not present.

To update all the fields in the entire document, select the entire document (Ctrl A) and press F9.

If the update takes too long, you can abort it by pressing Esc. Certain fields are not affected by performing an update because they do not pull information from a source that can be changed.

Most fields are not automatically updated each time you open or save the document.

(In this way, they differ from OLE linked objects, which are automatically updated by default.) To update a single field, select it (or click anywhere in it) and press F9, or right-click the field and choose Update Field.

I had a client’s Word 2007 document to work on and the fields took FOREVER to update.

In fact, I wasn’t even sure if they *did* update as I killed Word after an hour and a half of watching the ‘spinning wheel of death’…

Unlike formula, Word's field-codes are usually not updated automatically.

Tags: , ,