Debug error

[Paul W. Schu]

After installing Excel 2000 on a Win95 machine. When 1st
opening Excel I get an error: Microsoft Visual Basic
Compile error:Cannot find project or library. If I close
the box excel works fine. Annoying please help.

 

[Kristyn Wagoner [MSFT]]

If this is in regards to a specific worksheet, then this article may help :

208218 ACC2000: VBA Functions Break in Database with Missing References
http://support.microsoft.com/?id=208218

If it's Excel in general - try uninstalling and then reinstalling.

Hope that helps!
--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Chip Pearson]

Before installing and re-installing, try the following. Go to the Windows
Start menu, choose Run, and enter

Excel.exe /regserver

This will cause Excel to re-register itself with Windows, restoring the
"factory default" settings. This can cure a variety of ills.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Robert Christie]

Hi Chip
Could your fix be used on Excel XP 2002 as well?
TIA

Bob C

 

[Dave Peterson]

You can reregister excel with the same command in xl2002. (But I don't know if
it'll fix your problem. But you will in a matter of seconds.)