Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-02-2014, 11:37 PM
sectionbreak sectionbreak is offline how to update calculated fields Windows 7 64bit how to update calculated fields Office 2013
Novice
how to update calculated fields
 
Join Date: Jun 2014
Posts: 3
sectionbreak is on a distinguished road
Default how to update calculated fields

Hi,

ive got a problem with updating calculated fields.

Normally the mail merge fields get updated before printing (as set in the options), but the calculated fields won´t.

I´m doing the mail merge with an open xml component (not word) and use mergefields to calculate some values.
e.g.
{ ={MERFEFIELD a} + {MERGEFIELD b}}



The result is:
{ =12 + 4} so the math can be done by word.

The openxml component is not working perfectly so the shown text for the result is: syntax error.

If i update the field manually (either by clicking on a single field or selecting all fields an clicking update fields) the math is done by word again and the text is updated correctly.
My problem is that i need to print these documents without updating them manually. Is there an option i´am missing? I can´t use any vba scripts.

See also the attached example document.
Attached Files
File Type: docx example.docx (13.5 KB, 14 views)
Reply With Quote
  #2  
Old 06-03-2014, 06:25 PM
macropod's Avatar
macropod macropod is offline how to update calculated fields Windows 7 32bit how to update calculated fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Do you have Word's 'update fields before printing' option checked? That said, I'm surprised the fields don't calculate automatically during the mailmerge. There is no 'openxml component' involved, so I wonder how you're doing this.

You can also update all the fields by Ctrl-A, F9.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-03-2014, 11:39 PM
sectionbreak sectionbreak is offline how to update calculated fields Windows 7 64bit how to update calculated fields Office 2013
Novice
how to update calculated fields
 
Join Date: Jun 2014
Posts: 3
sectionbreak is on a distinguished road
Default

Hi,

as is said before, the option is set and if i upate the fields manually, the fields get updated.

Have you opened the file? Do the fields get updated before printing?
Reply With Quote
  #4  
Old 06-03-2014, 11:46 PM
macropod's Avatar
macropod macropod is offline how to update calculated fields Windows 7 32bit how to update calculated fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by sectionbreak View Post
Have you opened the file? Do the fields get updated before printing?
What do you take me for? of course I opened it. How else do you suppose I was able to provide the advice in my reply??? And yes, the fields do update before printing.

If they're not updating for you, that suggests either you've checked the wrong options or there is a fault with your Office installation (a repair might be in order).

You could also avoid the issue by embedding your formula fields inside a QUOTE field, which would force them to update and be converted to static text in the output document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 06-04-2014, 12:12 AM
sectionbreak sectionbreak is offline how to update calculated fields Windows 7 64bit how to update calculated fields Office 2013
Novice
how to update calculated fields
 
Join Date: Jun 2014
Posts: 3
sectionbreak is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
If they're not updating for you, that suggests either you've checked the wrong options.
You were right - my fault. I´ve checked the wrong option.

Its working now - thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create calculated fields in Word Gooford Word 1 03-22-2012 06:25 AM
how to update calculated fields macro to update fields PeaceDove Word 3 01-17-2012 02:45 PM
Macro to update fields rhatx Word VBA 0 03-02-2011 12:14 PM
VBA to update certain (but not all) fields sparkyrose Word VBA 0 05-20-2010 12:50 PM
Can no longer update fields! slindsay Word 0 09-03-2009 05:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft