"Can't find project or library" - Can't access references screen either to try to fix!

[olimits7]

Hi,

I have an .xlsm file which has a module, it's been working fine for a while. I just saved it and then tried to open it and now I keep on receiving this "Can't find project or library" message all of sudden. Then if I try to open this same exact file on a different PC it works fine. Also, other co-workers don't have any issues opening this file.

I tried to follow the steps listed in the link below but I can't access the "References" screen so can't check on the check box.

Can't Miss! How to Fix Can't Find Project or Library Error?

When your Excel files can't find project or library error, you can get the solution from this page to fix it.

recoverit.wondershare.com

I don't understand why this file opens up properly on a different PC but all of sudden having this issue on my work PC which never showed this error before?

Thank you!

 

[olimits7]

On the PC I can open the file properly on, I ended up saving the file as an .xlsx, removing the macro, and then I added it back and saved it as an .xlsm. I then opened this file on the PC that was giving me issues and it was working for a bit but then I opened again and get the same "Can't find project or library" message again.

 

[olimits7]

Did this workaround, seems to work for now...

MSEXCEL 2016 VBE : Can't find project or Library error

At my Workplace which is a Home Office, running PC: Windows 10 Pro MS Office 2016, released via Office 365 Problem with: A specific MS Excel File (xlsm), that has been working perfectly fine since 2013. MS Office 365, has been on the machine for past 2 years. The Wb (lets say MyWB) is...

www.mrexcel.com