find which cell the #ref refers to

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
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...
 
Back
Top