View Single Post
 
Old 08-25-2016, 03:44 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by snowboarder2 View Post
If the end user wants to enter data vertically in one column at a time, it's not going to calculate in all fields.
That would only be the case if you don't have the 'calculate on exit' property set for all of the cells involved in the calculations. Since your document is password-protected, I can't really see what you have there. And, given the structure of your form (which has a bunch of other formfields after the data to be calculated), if you had the 'calculate on exit' property set for all of the cells involved in the calculations, you probably wouldn't need the 'Click to insure all totals calculate' checkbox.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote