[Cathy]

Yes, each tax billl has an embeded Excel object (house valuation times the
current tax rate per $100). The only thing I have to change is the tax rate
on each bill. All bills are under one MS document, one tax bill for each
page. This way all I have to do each year is change the rate if it changes
or change the owner when a home sells. If anyone knows of an easier way to
achieve this, I am always up for an easier way. I just thought this would be
the easiest and keep each years taxes in one document.

"Jean-Guy Marcil" wrote:

"Cathy" wrote:

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.


Do you mean that you have many embeded Excel objects, each using the same
Tax Rate, and that you need to change the tax rate in all those embeded
objects?