Missing reference

[Doug]

Running Excel 97 at s/r2, on W 98, when I enter data in a
cell I get a message "Can't find Library or Project"
I press OK and get the references dialog. The usual
references are there, but a selected reference is marked
"MISSING:" with the name field blank! The address is a
folder where I save worksheets normally. "E:\ExcelSheets"
The problem occurs only in one particular workbook. If I
create another w/book by copy file, or cut and paste
individual sheets, the infection is propagated to the new
file. This is a very large workbook, 11 sheets with
hundreds of formulas, hence not practical to rewrite.
Can any of the experts out there suggest something to
address this problem?

Tksalot in advance

 

[Simon Murphy]

Doug
Can you just remove the missing reference by un ticking
the box?
That usually works for me, with no bad side effects

cheers
Simon

 

[Guest]

-----Original Message-----
Doug
Can you just remove the missing reference by un ticking
the box?
That usually works for me, with no bad side effects

cheers
Simon

Hi Simon. Not this time. I cannot uncheck the box, because
the reference is in use!!!!!
This very weird. Tksalot for your reply>

 

[Nick Hodge]

Try unchecking it with windows in safe mode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

-----Original Message-----
Try unchecking it with windows in safe mode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)




Reply to Nick Hodge.

Safe mode has no effect on the problem, sorry to say.

Rgds Doug