If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Can't Find Project or Library

Thread starter MikeDBMan
Start date Oct 25, 2018
Tags

error file library microsoft object

MikeDBMan

Well-known Member

Oct 25, 2018

I have a problem with .xlsm files that are saved to SharePoint. Sometimes when I open a file up, I get the error "Can't find Project or Library". I can't view the references as I just get error messages in the VBA editor so I don't know what might be unchecked. I have always thought the file was corrupted and would restore an older version but I have a coworker who was able to open the file just fine. The difference is that she has SharePoint files macro-disabled so it opens without the macros being "available". So the file is actually okay. But does anyone have any ideas about how I could fix the missing library? Typically the only references I have checked are:

Visual Basic For Applications
Microsoft Excel 16.0 Object Library
OLE Automation
Microsoft Office 16.0 Object Library
Microsoft Forms 2.0 Object Library

If I try to save the file EXCEL Crashes.

Thoughts?