Hi derby46a,

Your document is basically OK, though it didn't have forms protection applied. Once applied, the formulae seem to work OK. I've also simplified the document a bit (see attached).

The main change was to replace you calculation formfields with regular forumula fields. Calculation formfields produce strange results when other calculation formfields reference them.

I also deleted all your bookmarks, except for 'Dropdown1'. As your text formfields are all in a table and use numeric values for the calculations, the formula fields can reference their cell addresses directly. It is also unwise to use bookmark names that correspond with Word's cell referencing convention. Doing so can lead to invalid results in documents with more than one table, or even with no tables.

Attached Files

TEST.docx (17.3 KB, 66 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you so, so much, macropod. It works! Thank you for cleaning it up, too. I went through to look at what you cleaned up; I didn't know I had too much info in the table.
Also, I changed the number format back to your suggestion, \# "$,0.00;($,0.00)" in the tax cell, D13, and it works just fine.

What a load off my shoulders! Thank you, again!

P.S. I couldn't find where I check off that this is solved, or I didn't know if you do it on your end (?)

macropod,

I have a similar issue. Once I signed on, I downloaded the Test (1).docx but it was locked. Can you send me the unlocked version, so I can see the code behind the solution?

Thansk!