[ArcticWolf]

Hi,

I've got some charts linked into a word doc from an excel sheet. Is there a
way I can update them all in one go (apart from closing and reopening the
file), instead of doing them all individually via 'update link' please?

TIA,

AW.

[Robert M. Franz [RMF]]

Hello Arctic

ArcticWolf wrote:
I've got some charts linked into a word doc from an excel sheet. Is there a
way I can update them all in one go (apart from closing and reopening the
file), instead of doing them all individually via 'update link' please?

with the cursor in the main text area: CTRL-A (SelectAll), followed by
F9 (UpdateFields) should do the trick.

Note: every Word "field" (Date, TOC, SEQ, INDEX, etc.) will be updated
that way.

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MSFT |
\ / | MVP | Scientific Reports
X Against HTML | for | with Word?
/ \ in e-mail & news | Word | http://www.masteringword.eu/

[ArcticWolf]

Hi Robert,

This works perfectly, many thanks. Thanks also for the prompt response.

ATB,

AW

"Robert M. Franz [RMF]" wrote:

Hello Arctic

ArcticWolf wrote:
I've got some charts linked into a word doc from an excel sheet. Is there a
way I can update them all in one go (apart from closing and reopening the
file), instead of doing them all individually via 'update link' please?

with the cursor in the main text area: CTRL-A (SelectAll), followed by
F9 (UpdateFields) should do the trick.

Note: every Word "field" (Date, TOC, SEQ, INDEX, etc.) will be updated
that way.

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MSFT |
\ / | MVP | Scientific Reports
X Against HTML | for | with Word?
/ \ in e-mail & news | Word | http://www.masteringword.eu/
.