Share via

MS Excel error "Can't find project or library"

Anonymous
2021-12-21T04:27:23+00:00

Hello,

I am using office 365 and facing a problem very spontaneously. that make unable to save changes my file. I'm using power Query and VBA in my files. these files are corrupting randomly showing notification of "Can't find project or library". Please help me out from this.

Thanks

Sazzad

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

16 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-12-21T08:54:34+00:00

    Hello, Sazzad

    Sorry for all the trouble it has caused. You can try repair Office see if it make any changes.: Repair an Office application.

    Open Excel and press Alt + F11. Click Tools > Reference. Do you find any missing reference in there? If so, try unchecking the checkbox next to the missing reference.

    For more information about this error you can check the official article https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/can-t-find-project-or-library

    Excel 2016 x64 “can’t find project or library”

    I understand sometimes the initial suggestion may not resolve the problem; however, we can work together to narrow down and resolve the situation. If the issue persists, please provide us with the following information:

    Office version: Open any Office app, click File > Account, look for the information under Product information.

    Windows version and build: press Windows key + R > type winver > OK

    Can you confirm if this issue happens with a specific VBA workbook?

    Regards,

    Igor

    6 people found this answer helpful.
    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2021-12-28T08:27:54+00:00

    Okay, from my point of view, the problem is not inside the file.

    Did you tried to repair your Office as Igor suggested (in the first reply)?

    Andreas.

    1 person found this answer helpful.
    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2021-12-27T13:35:12+00:00

    The file is fine, no issues. I guess this might be an issue to one of your AddIns.

    Please follow these steps:

    Close Excel
    Press and hold the CTRL key
    Open Excel
    Wait for a message to appear and ask for "Safe Mode"
    Release the CTRL key
    Click Yes
    After Excel opens
    Click File\Open and select your file
    Press and hold the SHIFT key
    Click Open
    Wait for your file to open
    Release the SHIFT key
    Test the behavior

    What happens?

    Andreas.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2021-12-22T08:57:53+00:00

    https://r***i4-my.sharepoint.com/:x:/g/personal/s****ad_khan_r***i_com_bd/ETO9Sd5WocBOvDn_88Oo_HoBD_0BtN42Y5ltZTl2GIRx0g?email=saz***d.khan%40****i.com.bd&e=Exqriy

    [PII is removed by Forum Moderator]

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2021-12-21T17:14:31+00:00

    Hello, Igor

    Thanks for your response. I am using Office 365 ProPlus. I tried mentioned step but "Reference" not working for corrupted file. it works for other file. It happened previously with a file contains VBA and Power Query, and I was unable to recover that. Again, I'm facing similar problem for another file contains VBA and Power Query.

    Thanks,

    Sazzad

    0 comments