Word Word 2007 form fails to auto calculate total

[pipwit57]

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]

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.

 

[pipwit57]

Hi Colossus?? i will give that a try - there's always hope - yes?

Thanks

Pipwit

 

[pipwit57]

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

 

[pipwit57]

Oops, I meant to say "Word 2007"

 

[pipwit57]

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