May 10 2023 03:53 PM
Hello All,
A large table in a Word document contains multiple formulas, each in its own cell, and all formulas in the same column.
Is there a way to update *all* of the formulas in the column simultaneously, as opposed to having to do each one separately?
Thanks in advance.
BG
May 10 2023 08:02 PM
Solution@Bruce_Gettel To update all of the fields in the document, press CTRL+a and then press F9. To just update the fields in the column in the table, select the column and then press F9.
May 26 2023 03:04 PM
@Doug_Robbins_Word_MVP When I use this command sequence, I get an error message that the fields are nested too deeply. It appears after the dialog boxes asking if I want to update just the page numbers or the whole field for the TOC, TOF, and TOT. I've never seen this error before on this or any other Word document. Can you tell me what it means?
May 26 2023 05:57 PM
@Torchy_777 Can you share a copy of the document (on OneDrive, DropBox, etc.) so that we can investigate the issue
May 30 2023 06:46 AM
@Doug_Robbins_Word_MVP no, I'm sorry, I can't share it. It's company proprietary. The exact wording of the error message was "Fields are nested too deeply" if that helps. When I did the Ctrl+A then F9, I got the usual dialog boxes asking if I wanted to update the entire table or just the page numbers for the three tables (Table of Contents, List of Figures, and List of Tables). It doesn't matter which option I select; I get the same error message as soon as the third dialog box closes.
May 30 2023 01:06 PM
@Torchy_777 We can't help without seeing the field construction. Can you strip out any confidential matter so that you can share the rest of the document.