Hi Cathy,
If you open up the embedded Excel object and select the 'tax rate' cell, you can copy that, close the Excel object and paste the
cell contents as a link wherever you want in the document. You do this via Edit|Paste Special. When pasting, Word also gives you a
choice of paste formats - I'd suggest the formatted or unformatted text options, depending on your requirements. After pasting once,
you can simply make a copy of the pasted data then paste that wherever else you want in the document. Thereafter, updating the
values throughout your document will be a simple matter of updating the value in the Excel object, then selecting the whole document
(Ctrl-A) and pressing F9 (printing the document or doing a Print Preview should also work if you've got the 'update fields' option
checked unto Tools|Options|Print).
Cheers
"Cathy" wrote in message news
The Tax Rate is embeded in the Excel object. It is part of the formula and
is not directly seen in the document itself. I have not tried Find/Replace
yet. Thanks for your help.
"Jean-Guy Marcil" wrote:
"Cathy" wrote:
I created a tax form for our City using Excel in the Word document. I need to
make the a rate change. Is there a way to make the rate change on the 1st
page and have it make the same change on all of the remaining pages without
changing each page?
More information will be needed.
Where is this rate? In the embeded Excel objects, in the Word document main
story text, in the header...???
How is this rate used? Is it part of formulas, but not directly seen in the
document itself...
Have you tried Find/Replace?