Update Fields in Long Documents

[Darlynne]

I have documents that contain many sequence and formula
fields. When I print preview the document, all the fields
display as 0.00 and they stay that way until I go back and
select the entire document and update all the fields. This
only happens if print options are not set to update
fields, and I understand that, but here's the problem:
Some of these documents contain hundreds of fields (Excel
was not an option). If I turn on the update on print
option, going into print preview can take a long time; if
I don't turn that feature on, then all my numbers are,
temporarily, zeroed out, which requires a lengthy manual
update of all fields. Can anyone recommend a best practice
or alternative for situations like this? The fields are in
tables and I could update just certain tables as needed,
but that seems clunky. Thanks.

 

[macropod]

Hi Darlynne,

If this is happening with newly-openned documents, rather
than updated ones, you could add an auto macro to update
the fields on open:

Sub AutoOpen()
Dim oSection As Section
Dim shp as Shape
Dim oHeadFoot As HeaderFooter
ActiveDocument.Fields.Update
For Each oSection In ActiveDocument.Sections
For Each oHeadFoot In oSection.Footers
If Not oHeadFoot.LinkToPrevious Then
oHeadFoot.Range.Fields.Update
End If
Next
For Each oHeadFoot In oSection.Headers
If Not oHeadFoot.LinkToPrevious Then
oHeadFoot.Range.Fields.Update
End If
Next 'oHeadFoot
Next 'oSection
For Each shp In doc.Shapes
With shp.TextFrame
If .HasText Then
.TextRange.Fields.Update
End If
End With
Next
End Sub

This will go through all fields and update them
automatically. It'll still take as long, though. If that's
a problem, you could always use this to show your boss
that you need a faster computer ...

Cheers
PS: Remove NO.SPAM from the above before replying.

 

[Darlynne]

I like the idea of faster computers, but this is for
updated documents. The issue has turned into one of
sequence fields not updating at all during print preview
even with the option to do so turned on, so I posted a
question to the print forum. Thanks for your help.