I am trying to add captions to several dozen linked Excel tables (set to
manual update only). There are several chapters. I can insert the captions
without difficulty. However, their numbers are all off by one until I
manually update them. The captions should be as follows:

Table 1-1, Table 1-2, Table 2-1, etc.

However, instead, for those same tables, I get:

Table 1-2, Table 1-3, Table 2-2, etc.

Each table in each chapter starts out as number 2 and all the subsequent
tables are off by 1 too high. Why? The chapter numbers always appear
correctly.

If I right click on the table number and select Update Field, or select the
caption text and press F9, it immediately flips to the correct number.

Is there a way to update all the fields in my document at once? In the help
it says to select all and press F9. That conveniently ignores captions
because they are in text boxes (it does get the TOC and other fields that
are not in headers, footers, or text boxes).

Is there a way to avoid this whole problem in the first place?

Thanks,
Colin