View Single Post
 
Old 08-23-2016, 08:12 AM
snowboarder2 snowboarder2 is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Aug 2016
Posts: 26
snowboarder2 is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
You can put an ordinary (non-form) calculation field in a protected document. So long as the formfields on which it is based have "calculate on exit" checked. Note that you may have to tab out of the last field in which you enter data to trigger this.

That is, your Totals and Variance fields could all be ordinary calculation fields. You would need to assign bookmarks to the variance fields.
Thanks for the tip about tabbing out of the last field to to trigger the calculation. It was giving me problems. I'm afraid this is going to be problematic for the end user. Ultimately, I'm afraid I'll just have to ditch the auto calculation or formula options and have the end user enter their own sums.
Reply With Quote