Excel VBA: Can't find project or library

Running Windows 10
Microsoft Excel 16
64 bit

Just encountered this issue - Opening a normal file with a small amount of VBA coding.

On opening file today, ran into error "Can't find project or library"

Error appeared in a few files, and after restarting was localized to a single file.

Answer

Steps:

1. panic


2. Repaired Microsoft Office



3. removed personal.xlsb file from XLStart to test


4. Opened blank excel, Alt + F11 to open VBA


5. Tools -> References -> Object Library


6. Search for missing objects


7. Corrected if found


8. These steps didn't resolve, so renamed the file opened in safe mode (win + R type Excel.exe /safe)


9. Updated dates, changed a few items and saved


10. Opened file normally, issue resolved.

Alternatively, try to have someone else open the file/update name and change a few things for you. the file is likely corrupt