Help with "Cannot find object or library"

[DrBacon]

Hello,

I tried to make this post yesterday, but I cannot seem to find it. Maybe I posted it wrong. Anyway... thank you for taking your time to read this post.

Recently, all macros (even just using ctrl+w to close excel) is not working. I keep on getting the error mentioned on the header, and I cannot even get to the VBA to check what reference might be missing, as excel just crashes before that.

What can I do? Could reinstalling Excel altogether fix this?

Thank you all! Please let me know what additional information you might need to delve into this a bit deeper.

Cheers
Bacon

 

[Rick Rothstein]

Can you open a brand new workbook and get look at the VB editor references there?

 

[DrBacon]

Hello Rick!

No, I cannot even open a blank workbook and try to go to the VB Editor.

 

[Rick Rothstein]

Hello Rick!

No, I cannot even open a blank workbook and try to go to the VB Editor.

Hmm, that sounds bad. Before reinstalling Excel, I would try repairing it first. In my copy of Windows 8.1, I would open the Control Panel, select Programs and Features, select Microsoft Office Professional Plus 2010 (Excel was installed along with other Office products on my computer) and click the Change item in the "option bar" immediately above the program name list... that brings up a dialog box where Repair is an option you can select.

 

[DrBacon]

I will try to get my IT department to do that. What I also saw is that if I open the file on a separate computer, it does not run into any issues.

 

[DrBacon]

Hmm, that sounds bad. Before reinstalling Excel, I would try repairing it first. In my copy of Windows 8.1, I would open the Control Panel, select Programs and Features, select Microsoft Office Professional Plus 2010 (Excel was installed along with other Office products on my computer) and click the Change item in the "option bar" immediately above the program name list... that brings up a dialog box where Repair is an option you can select.

This did not work , we tried to uninstall Office and it still gives me this issue

 

[Fazza]

was there an update to Excel since yesterday?