Missing reference

  • Thread starter Thread starter Doug
  • Start date Start date
D

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
 
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
 
-----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
Click to expand...

Hi Simon. Not this time. I cannot uncheck the box, because
the reference is in use!!!!!
This very weird. Tksalot for your reply>
 
Try unchecking it with windows in safe mode

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
-----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.
Click to expand...
Safe mode has no effect on the problem, sorry to say.

Rgds Doug
 
Back
Top