Excel updating fields
You might not see anything there (if the field is hidden), but after jumping to that spot, right-click the spot and choose Toggle Field Codes or press Shift F9, and the field appears.
A third way is to use the Go To feature to move from one field to the next.
If the field you want to lock does not have that switch as part of its syntax, here’s another way: Click in the field and press Ctrl F11.
To confirm that the field has been locked, right-click it; the Update Field command is unavailable on the menu that appears.
Before unlinking a field, update it one last time (F9) if needed.If neither of these methods works, check to make sure the field is not locked.Try unlocking it by selecting the field and pressing Ctrl Shift F11.To update multiple fields at once, select them as part of a contiguous selection range and press F9.
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.