Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell referenced elsewhere
Hi,
I have a workbook with a number of worksheets which I have inherited, one of the worksheets has about 100 entries of what on the face of appears to be just text. Is there anyway to find out if any of the other worksheets use the data in their formulas ie lookups etc? I suppose I could try and delete the worksheet in revison mode and see what happens, but I wondered if there was an easier way? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell referenced elsewhere
Select your cell. Then you can use "Trace Dependents" under Formula
Auditing. This can be found on the TOOLS menu in Excel 2003 or on the FORMULAS Tab in Excel 2007. HTH Elkar "Dave Eade" wrote: Hi, I have a workbook with a number of worksheets which I have inherited, one of the worksheets has about 100 entries of what on the face of appears to be just text. Is there anyway to find out if any of the other worksheets use the data in their formulas ie lookups etc? I suppose I could try and delete the worksheet in revison mode and see what happens, but I wondered if there was an easier way? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
need value from referenced cell | Excel Worksheet Functions | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
See where a cell is referenced | New Users to Excel | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |