find which cell the #ref refers to

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Triza - 22 Feb 2007 17:11 GMT

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

Reply to this Message

john - 22 Feb 2007 18:20 GMT

I don't think so - have you got a working backup of the file you could refer
to?

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> Excel 2003 Professional
> I have a workbook with formulas that reference data in other workbooks.
[quoted text clipped - 3 lines]
> Thanks,
> Pat

Reply to this Message

Triza - 22 Feb 2007 18:35 GMT

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

> I don't think so - have you got a working backup of the file you could refer
> to?
[quoted text clipped - 6 lines]
> > Thanks,
> > Pat

Reply to this Message