Let's say your formula is:

=Sheet3!B9

It can be changed to
=INDIRECT("Sheet3!B9")

and you can delete Sheet3. THis will give you a place to start.


"Mary" wrote:

Hello,
I have a master worksheet on which I have referenced cells from other
worksheets in my file. When I delete these other worksheets, I get a Ref#
error. How can I program the master worksheet to keep the reference intact so
that when worksheets are added back in, the reference is valid?
Thank you in advance for your reply,