Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auditing tool question
hi to all,
i do not know how to make this possible in my excel2003SP2 i have 2 files. myfile1 contain cells that are used or referred by myfile2... when both files are open and i click Trace dependent on a cell in myfile1...i can see that this cell is being referred by myfile2....then i save and close both files.... when i open again only myfile1....and i click Trace dependent on the same cell...a pop up says that " ! The Trace Dependents COMMAND found NO formulas that REFER to the active cell." - an "OK" button appears as well.... how can i make this "OK" <trace dependent COMMAND...to assure that i can be alarmed before deleting or cut/pasting this cell....since i cannot remember the hundreds of cells linked to many different workbooks.... please help regards -- ***** birds of the same feather flock together.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Audit Tool Question | New Users to Excel | |||
Question about Excel (Office) auditing/changes | Excel Programming | |||
Automatic Config Tool Question | Excel Programming | |||
Auditing Question | Excel Worksheet Functions | |||
tool bar question | Excel Worksheet Functions |