Thread: [Solved] How to link checkbox to change nearby cell value?
View Single Post
 
Old 08-25-2012, 10:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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
File Type: docx TEST.docx (17.3 KB, 66 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote