My Excel friends,
All over the Internet there are explanations about solving this issue in an XLSM file. However, none of the available “solutions” solved my problem. I found a “workaround” easy FIX that may fix your specific file, I will explain the process step by step:
1.- In Windows Explorer, make a backup of your “Can't Find Project or Library.xlsm” file. (Copy and Paste in Windows Explorer)
2.- In Windows Explorer, change a bit the filename of your “Can't Find Project or Library.xlsm” file. Close the Excel file first prior to changing the name. Otherwise, you will not be able to do it.
3.- Run Excel and by using the Excel menu open your “Can't Find Project or Library (new filename).xlsm” file.
4.-When opening, DO NOT ENABLE MACROS. If you Enable Macros, it triggers the “Can't Find Project or VBA Library Error”. If you do not change the filename (Step 2), this option to DO NOT ENABLE MACROS does not show up.
5.-Now SAVE THE FILE AS EXCEL WORKBOOK XLSX. Now you should have “Can't Find Project or Library (new filename).xlsx"
6.- CLOSE the “Can't Find Project or Library (new filename)”.xlsx (Closing it is Key. At this step, I have seen that some old non-usable XLSM modules still show up in the xlsx before closing it, so close it!. These "modules" should not be there. If you do no close at this step these modules may misbehave later on. It happened to me!)
7.- Reopen the “Can't Find Project or Library (new filename)”.xlsx (at this step your file is recovered, but you lost all your VBA code in it. There must not be any VBA modules in this xlsx file. All VBA modules should disappear)
8.- Save As again the file, this time as XLSM, add the word "recovered" to the name, you should have now “Can't Find Project or Library (recovered).xlsm” Close it again, now open it again and VERIFY that the ugly message "Can't Find Project or VBA Library Error" does not show up. Make a few backups in different locations!!!!
9.- If you have a prior working old version of your file, you may copy the VBA code from there to the new one, and rebuild the buttons or other Excel features in your fresher recovered xlsm file. (Extra work but better than starting all over again)
The main Excel work is recovered at step 7, it worked for me, and I wanted to share the process with the fellow Excel warriors at Mr. Excel. I recovered one 500 MB Excel file that I have been working in for at least six months. I have many backups, but anyways I would have lost some fundamental changes and hours of work. I was able to recover all my customized VBA macros taking the code from prior versions.
Do not forget to backup up regularly! Save regularly not just in Excel, do it in Windows Explorer copy and paste your file every hour or so, you will end up with many files with the same filename plus "- Copy (x).xlsm", x =1,2,3.... It is worth the extra seconds it takes. It is not the same as having the last version automatic xlk backup from Excel, it happened to me, it was also corrupted wit the same message. (I use Excel 2019 and Windows 10)
Please, like it and comment if it helped you.
Thanks!
All over the Internet there are explanations about solving this issue in an XLSM file. However, none of the available “solutions” solved my problem. I found a “workaround” easy FIX that may fix your specific file, I will explain the process step by step:
1.- In Windows Explorer, make a backup of your “Can't Find Project or Library.xlsm” file. (Copy and Paste in Windows Explorer)
2.- In Windows Explorer, change a bit the filename of your “Can't Find Project or Library.xlsm” file. Close the Excel file first prior to changing the name. Otherwise, you will not be able to do it.
3.- Run Excel and by using the Excel menu open your “Can't Find Project or Library (new filename).xlsm” file.
4.-When opening, DO NOT ENABLE MACROS. If you Enable Macros, it triggers the “Can't Find Project or VBA Library Error”. If you do not change the filename (Step 2), this option to DO NOT ENABLE MACROS does not show up.
5.-Now SAVE THE FILE AS EXCEL WORKBOOK XLSX. Now you should have “Can't Find Project or Library (new filename).xlsx"
6.- CLOSE the “Can't Find Project or Library (new filename)”.xlsx (Closing it is Key. At this step, I have seen that some old non-usable XLSM modules still show up in the xlsx before closing it, so close it!. These "modules" should not be there. If you do no close at this step these modules may misbehave later on. It happened to me!)
7.- Reopen the “Can't Find Project or Library (new filename)”.xlsx (at this step your file is recovered, but you lost all your VBA code in it. There must not be any VBA modules in this xlsx file. All VBA modules should disappear)
8.- Save As again the file, this time as XLSM, add the word "recovered" to the name, you should have now “Can't Find Project or Library (recovered).xlsm” Close it again, now open it again and VERIFY that the ugly message "Can't Find Project or VBA Library Error" does not show up. Make a few backups in different locations!!!!
9.- If you have a prior working old version of your file, you may copy the VBA code from there to the new one, and rebuild the buttons or other Excel features in your fresher recovered xlsm file. (Extra work but better than starting all over again)
The main Excel work is recovered at step 7, it worked for me, and I wanted to share the process with the fellow Excel warriors at Mr. Excel. I recovered one 500 MB Excel file that I have been working in for at least six months. I have many backups, but anyways I would have lost some fundamental changes and hours of work. I was able to recover all my customized VBA macros taking the code from prior versions.
Do not forget to backup up regularly! Save regularly not just in Excel, do it in Windows Explorer copy and paste your file every hour or so, you will end up with many files with the same filename plus "- Copy (x).xlsm", x =1,2,3.... It is worth the extra seconds it takes. It is not the same as having the last version automatic xlk backup from Excel, it happened to me, it was also corrupted wit the same message. (I use Excel 2019 and Windows 10)
Please, like it and comment if it helped you.
Thanks!
