find which cell the #ref refers to

G

Guest

Excel 2003 Professional
I have a workbook with formulas that reference data in other workbooks.
Someone deletes a cell in the workbook with the referenced data. Now the
formula shows [workbookname.xls]Sheet1!#REF! Is there any way to show which
cell the formula originaly referenced?
Thanks,
Pat
 
G

Guest

I don't think so - have you got a working backup of the file you could refer
to?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
G

Guest

Yes, but the files are so large that it would take hours to compare them.
Pat

john said:
I don't think so - have you got a working backup of the file you could refer
to?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


Triza said:
Excel 2003 Professional
I have a workbook with formulas that reference data in other workbooks.
Someone deletes a cell in the workbook with the referenced data. Now the
formula shows [workbookname.xls]Sheet1!#REF! Is there any way to show which
cell the formula originaly referenced?
Thanks,
Pat
Click to expand...
Click to expand...
 

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

Cannot find #REF!#REF error 0
Excel Sumproduct Ref error when table is closed 0
Too many decimals when using =[cell reference]&"[text]" 2
Reference Formula Help 1
Extremely slow calculation of formulas 4
Cell reference - displays formula rather then referenced cell 2
Save with ref. to cell A1 2
how to find #ref! invalid cell references within cell formula 6

Top