| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max to specific references | Excel Worksheet Functions | |||
| How do I set up a Custom Header that references a specific cell | Excel Discussion (Misc queries) | |||
| deleting worksheet and associated references | Excel Discussion (Misc queries) | |||
| worksheet references | Excel Discussion (Misc queries) | |||
| Cell References from old worksheet to new worksheet. | Excel Discussion (Misc queries) | |||
Linear Mode
