Can't find project or library

%3CLINGO-SUB%20id%3D%22lingo-sub-1713557%22%20slang%3D%22en-US%22%3ECan't%20find%20project%20or%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713557%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20several%20copies%20of%20an%20Excel%20model%20that%20continues%20macros.%26nbsp%3B%20Usually%2C%20they%20work%20fine%20but%20every%20once%20in%20a%20while%2C%20when%20I%20open%20one%20in%20Excel%202013%2C%20I%20get%20the%20error%20%22Can't%20find%20project%20or%20library%22.%26nbsp%3B%20Then%2C%20my%20file%20is%20unable%20to%20be%20saved%20from%20that%20point%20due%20to%20corruption.%26nbsp%3B%20I%20cannot%20save%20it%20as%20a%20macro-free%20%22xlsx%22%20file%20either%20due%20to%20the%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20work%20around%20the%20problem%20by%20opening%20my%20file%20in%20Excel%202010%2C%20then%20re-saving%20it.%26nbsp%3B%20This%20fixes%20the%20problem%20for%20the%20corrupted%20file%20as%20if%20it%20never%20happened.%26nbsp%3B%20However%2C%20I%20have%20several%20members%20on%20my%20team%20who%20do%20not%20have%20Excel%202010%20and%20are%20therefore%20stuck%20with%20a%20corrupted%20file%20or%20they%20have%20to%20send%20it%20to%20me%20for%20a%20fix.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20follow%20the%20directions%20online%3A%26nbsp%3B%20Alt-F11%20to%20go%20to%20Visual%20Basic%2C%20click%20%22Tools%22%2C%20%22References%22%20and%20unselect%20any%20libraries%20not%20found.%26nbsp%3B%20But%2C%20the%20%22References%22%20menu%20will%20not%20load%20when%20I'm%20in%20one%20of%20my%20corrupted%20files.%26nbsp%3B%20When%20I%20click%20%22References%22%20it%20simply%20returns%20me%20to%20the%20Visual%20Basic%20window%20without%20bringing%20up%20the%20menu.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20have%20to%20remove%20my%20macros%20from%20my%20models%20since%20they're%20very%20useful%20but%20I%20can't%20have%20my%20models%20randomly%20corrupting%20themselves%20like%20this%20for%20my%20team%20members.%26nbsp%3B%20Please%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBrandon%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1713557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2082248%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20find%20project%20or%20library%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2082248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F809196%22%20target%3D%22_blank%22%3E%40bjquijada%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexact%20same%20problem%20here.%26nbsp%3B%20any%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Everyone,

 

I have several copies of an Excel model that continues macros.  Usually, they work fine but every once in a while, when I open one in Excel 2013, I get the error "Can't find project or library".  Then, my file is unable to be saved from that point due to corruption.  I cannot save it as a macro-free "xlsx" file either due to the errors.

 

I can work around the problem by opening my file in Excel 2010, then re-saving it.  This fixes the problem for the corrupted file as if it never happened.  However, I have several members on my team who do not have Excel 2010 and are therefore stuck with a corrupted file or they have to send it to me for a fix.

 

I tried to follow the directions online:  Alt-F11 to go to Visual Basic, click "Tools", "References" and unselect any libraries not found.  But, the "References" menu will not load when I'm in one of my corrupted files.  When I click "References" it simply returns me to the Visual Basic window without bringing up the menu.

 

I don't want to have to remove my macros from my models since they're very useful but I can't have my models randomly corrupting themselves like this for my team members.  Please help!

 

Thanks,

Brandon

4 Replies

@bjquijada 

exact same problem here.  any solution?

@bjquijada 

I had the same the problem - this is how i managed to fix:

1) Close the file/excel down

2) Right click on file, properties, security, edit access, remove all accesss

3) At this point you likley cant access the file

4) Right click on file, properties, security, edit access, add full control, to yourself, typically your email address linked to MS account

5) Open the file, Alt F11

6) Now you should be able to access the references (Alt F11, Tools, References)

7) For me, there was one unticked reference linked to the file, tick this
This solved the problem for me.

Please let me know if this fixes for you.

I had the same the problem - this is how i managed to fix:

1) Close the file/excel down

2) Right click on file, properties, security, edit access, remove all accesss

3) At this point you likley cant access the file

4) Right click on file, properties, security, edit access, add full control, to yourself, typically your email address linked to MS account

5) Open the file, Alt F11

6) Now you should be able to access the references (Alt F11, Tools, References)

7) For me, there was one unticked reference linked to the file, tick this
This solved the problem for me.

Please let me know if this fixes for you.
I get this same problem, use the Excel 2010 fix too. Nothing else as worked for me.