View Single Post
 
Old 08-23-2016, 07:27 AM
Charles Kenyon Charles Kenyon is offline Windows 8 Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote