In Excel errors in open file

Question

The Excel file was working fine. Today, the Excel file is opened but "cann't find the library and project". All the codes in marcos are gone can not view. Can you export modules anymore. Try to open the Tool and reference. No window open when hit the "Tool". Like to recover all the code from the files.

Please help.

Answer 1

@Ben Tse

According to your description, please check whether other computer could open this Excel file correctly.

If this Excel files could be opened successfully on other computers, you may try to exprot modules.
I would also suggest you go back to the previous computer, create a new blank workbook, check whether you could run macros and open this files later.
If all files with macros have this issue, please repair Office from Control Panel.

If this Excel file could not be opened correctly on other computers, maybe there is something wrong with it.
Please refer to Romain PH's and nigelbarrett's reply in this thread "Excel 2016 x64 “can’t find project or library”".

Hope the information, could help you,

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.