References to a specific worksheet
 

Is there a way that I can know if any cells in a worksheet reference cells in
another worksheet. Sometimes when I want to delete a sheet I want to know
beforehand whether there are any open references to the sheet in other
sheets??
--
James D. Sheehan

References to a specific worksheet
 

Simple way. Do a find on !

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"James D. Sheehan" wrote in
message ...
Is there a way that I can know if any cells in a worksheet reference cells
in
another worksheet. Sometimes when I want to delete a sheet I want to know
beforehand whether there are any open references to the sheet in other
sheets??
--
James D. Sheehan

References to a specific worksheet
 

On Oct 1, 11:27 am, James D. Sheehan
wrote:
Is there a way that I can know if any cells in a worksheet reference cells in
another worksheet. Sometimes when I want to delete a sheet I want to know
beforehand whether there are any open references to the sheet in other
sheets??
--
James D. Sheehan

If there are not many formulas, you could go to tools/options/view and
click formulas and look at all of the formulas to see if there was a
reference to another sheet. This works OK when you dont know what to
do a "find" for.