Creating fill in form with plain text and autosum table

Using Word 2010 in Windows 7. 

I am trying to create a form that users can fill in blocks of text, and it includes a budget table. I have figured out the developer tools and protected content, and have it set to "fill in forms". The problem is that I can't get the budget table to auto-sum, and once in protected mode the users can't right click to "update formula". We tried to embed an excel file, but it's not editable once protected in the "fill in forms", and I can't select the form boxes and the excel file to set a partial exception. 

Is it just impossible to create a form with both fill in forms and a fill in budget table that auto updates it totals? 

Is the sum based on input in the text form fields? If so, and assuming that you have the formula field correctly referencing the form fields to add, what you need to do is check the box for "Calculate on exit" in each of the text form fields that contributes to the total.
Microsoft MVP (Word) since 1999
Fairhope, Alabama USA
http://ssbarnhill.com
http://wordfaqs.ssbarnhill.com
Screen shots captured with TechSmith's Snagit

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 519 Applies to: