Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, and 2013. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Field Calculations in Locked Forms.

Field Calculations in Locked Forms

by Allen Wyatt
(last updated January 5, 2018)

2

Kathleen described a problem she had with Word not updating a calculated field in a locked form. For instance, if there are three fields (Field1, Field2, and Field3) that are summed together into another field (Total), then Kathleen could not get the Total field to calculate, even though she set the Calculate on Exit property of the Total field.

The reason the problem occurs is a misunderstanding of the way in which Word calculates form fields; it has nothing to do with the fact that the form is locked. (In fact, the form must be locked in order to fill in the form fields at all.) The problem arises because it is not the Total field that must have the Calculate on Exit property turned on, but the fields on which Total is dependent. In this instance all three contributory fields—Field1, Field2, and Field3—must have their Calculate on Exit property set. If they do, then the Total will update properly (and interactively) as expected.

As a side note, it does very little good to have the Calculate on Exit property set in the Total field. Why? Because when you set the field's Type property to Calculation, enter your formula in the Form Field Options dialog box, and then lock the form, the Total field cannot be selected. If it cannot be selected, you can't exit it (you can't exit what you can't enter), so the Calculate on Exit property is never triggered.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8178) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Field Calculations in Locked Forms.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Making Spell Check Ignore Characters

The rules of professional editing often require that editorial changes in a quote be noted with brackets. These brackets, ...

Discover More

Inserting the Author Name

Did you know that Word tries to keep track of who the author of a document is? This information can be easily added to ...

Discover More

Setting Print Ranges for Multiple Worksheets

Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (ribbon)

Moving Footnote References Using Find and Replace

When you are editing a document, you may need to modify where the author placed footnotes relative to surrounding ...

Discover More

Referencing Fields in Another Document

Sometimes you may have two documents that are so integrally related to each other that the one document may require the ...

Discover More

Limiting Directories in the FILENAME Field

When you use the FILENAME field in a document, it can include the full path name that leads to your file. This might be ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 4 + 7?

2019-07-25 21:11:19

Melodie K Ford

Allan - I just have to say this. You ROCK...seriously. I have been searching for this answer for days! I don't know why I didn't just come here first. You have always had the clues and tips I need to get my work done. Thankyou.


2019-06-30 18:32:31

Loredana Cornea

I have the same issue in a slightly different scenario.
I calculate Total=Quantity * Price.
Quantity is a number, checked "Fill-in enabled", checked "Calculate on exit"
Price is a number with a default, UNCHECKED "Fill-in enabled" (I don't want users to change this value), checked "Calculate on exit"
Total is a Calculation field with the following formula: =B2*C2
When I hit OK in the Total field definition, its value updates correctly, but I cannot make it update after I restrict the file as a form.
Any ideas how I can fix this issue?


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.