Updating Formula Results

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kitty - 05 Oct 2004 20:12 GMT

I have a table with a few calculations. Nothing fancy.

Is there a way to update all formula results at once,
without having to click each one and pressing F9? I know
I can set Word to update the fields when I print, but I
don't want to have to do that to update the formulas if I
change one of the numbers.

Thanks!

Kitty

Reply to this Message

Greg - 05 Oct 2004 20:29 GMT

Kitty,
CTRL+a (select all) then F9 or if you have update fields
as a print option then you can toggle in and out of print
preview.

You can also put the following macro in you template and
then assign it to a keyboard shortcut or menu command:

Sub UpdateFields()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing
End Sub

>-----Original Message-----
>I have a table with a few calculations. Nothing fancy.
[quoted text clipped - 9 lines]
>Kitty
>.

Reply to this Message

Kitty - 06 Oct 2004 11:38 GMT

Thanks!

>-----Original Message-----
>Kitty,
[quoted text clipped - 34 lines]
>>
>.

Reply to this Message