Word Word 2007 form fails to auto calculate total

Joined
May 23, 2012
Messages
11
Reaction score
0
Hi fellow PCReviewers

I'm having difficulties with my Word 2007 form. I have set it up to allow fields to be populated and have the sum total appear in another field. Unfortunately I am having no success in regards to the total automatically updating as data (numbers) are being populated.The F9 fails to update the total as well.

I have checked and double checked the properties and it all seems fine to me, ie, data fields all set to "calculate on exit", the total sum field is not set to "calculate on exit" and the calculation formula reads =Text1+Text2+Text3+Text4 i've even used =sum(Text1+Text2+Text3+Text4) without success.

As a footnote, I am able to open a former 2003 Word form and it does behave correctly. The form outlined above was created in W2007.

Can anyone help me please
Cheers
Mark
 

nivrip

Yorkshire Cruncher
Joined
Mar 21, 2007
Messages
10,952
Reaction score
2,144
Have you tried embedding an Excel table into Word?

As Help says -

If you have a spreadsheet application, such as Microsoft Office Excel, embedding (embed: To insert information created in one program, such as a chart or an equation, into another program. After the object is embedded, the information becomes part of the document. Any changes you make to the object are reflected in the document.) all or part of a worksheet in a document is often easier than using the = (Formula) field in a table.
 
Joined
May 23, 2012
Messages
11
Reaction score
0
Hi Colossus

I've explored the solution you suggested however I don't feel this would be beneficial considering the users who will be asked to populate the excel spreadsheet - big chance of them corrupting my data / graphs etc.

Can I assume the auto populate in a calculated field simply doesn't work in Word 2010. Other comments found on the net suggest work arounds but none have stated directly that it works fine. I'm really confused.

Again, thanks for your suggestion.

Pipwit
 
Joined
May 23, 2012
Messages
11
Reaction score
0
Please.....can anyone help with this issue about Word 2007 form not calculating data entered. A Word 2003 doc I have access does calculate (as long as it is retained as a Word 2003 doc).

I am desperate - can't somebody assist please!!!!

Cheers
Pipwit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top