#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
Quote:
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] |
#5
|
|||
|
|||
Quote:
Its working now - thank you. |
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 |
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 |