Auditing tool question

D

driller

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

maybe by cell coloring with embedded comment 0
maybe i can get reply here... 0
macro to insert a comment 0
how do I print .doc files from a list of pathnames in a spreadshee 1
My trace dependents is not working 0
non basic code in call stack 3
VBA for Dependents shortcut menu 0
Tracing Dependents on a Protected sheet 0

Top