Project or Library Not Found

%3CLINGO-SUB%20id%3D%22lingo-sub-3476435%22%20slang%3D%22en-US%22%3EProject%20or%20Library%20Not%20Found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3476435%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20continuous%20problem%20for%20us.%26nbsp%3B%20Not%20sure%20what%20is%20causing%20it%20but%20we%20get%20the%20error%20once%20a%20month%20and%20we%20have%20to%20recover%20our%20file%20from%20backup.%26nbsp%3B%20%26nbsp%3BExcel%20does%20not%20allow%20us%20to%20interact%20with%20the%20Tools%20and%20References%20in%20the%20developer%20window.%26nbsp%3B%20It%20does%20not%20show%20any%20code%20and%20it%20does%20nto%20allow%20us%20to%20click%20on%20any%20of%20the%20modules.%26nbsp%3B%20Its%20like%20ti%20completely%20blows%20up%20the%20VBA%20code.%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20normal%20process%20is%20to%20recover%20the%20file%20but%20if%20we%20accidently%20forget%20to%20click%20the%20backup%20button.%26nbsp%3B%20It%20makes%20things%20inefficient.%26nbsp%3B%20I%20know%20sometimes%20its%20a%20missing%20reference%20but%20this%20just%20happens%20randomly%20without%20warning.%26nbsp%3B%20Are%20there%20any%20steps%20I%20can%20take%20to%20fix%20this%20or%20overide%20without%20backup%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20real%20bummer.%26nbsp%3B%20Maybe%20one%20of%20you%20experts%20out%20here%20has%20seen%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378135i7916EEF0E444E9BC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22VeeExcelLearn_1-1654603950409.png%22%20alt%3D%22VeeExcelLearn_1-1654603950409.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3476435%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%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-3476730%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20or%20Library%20Not%20Found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3476730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F983378%22%20target%3D%22_blank%22%3E%40VeeExcelLearn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20an%20expert%2C%20but%20it%20could%20come%20from%20Excel%20Online.%3CBR%20%2F%3EIf%20someone%20opens%20this%20in%20Sharepoint%2Fweb%2FOneDrive%2Fhard%20drive%20in%20Excel%20Online%20and%20then%20saves%20it%20and%20makes%20it%20available%20to%20everyone%20again%2C%20all%20the%20macros%20are%20no%20longer%20available.%3C%2FP%3E%3CP%3ESince%20Excel%20Online%20doesn't%20recognize%20VBA%2C%20it%20removes%20that%20as%20well.%3CBR%20%2F%3ESometimes%20it%20also%20happens%20through%20the%20preview%20window%20in%20sharepoint%20or%20web%2C%20where%20some%20user%20does%20it%20automatically%20click%20and%20the%20file%20opens...with%20the%20indicated%20problem%2C%20in%20your%20sent%20image.%20Perhaps%20someone%20is%20working%20with%20Excel%20for%20the%20web%20and%20is%20causing%20this%20unknowingly.%3CBR%20%2F%3ESomething%20like%20this%20could%20also%20be%20caused%20by%20team%20use%2C%20since%20when%20sharing%20the%20Excel%20file%2C%20the%20team%20perceives%20and%20edits%20the%20file%20as%20Excel%20Online.%3C%2FP%3E%3CP%3EAs%20I%20said%2C%20I'm%20not%20an%20expert%20and%20all%20of%20this%20is%20without%20guarantee%20%3A).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helped%20maybe...if%20not%20please%20just%20ignore%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3476782%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20or%20Library%20Not%20Found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3476782%22%20slang%3D%22en-US%22%3EThis%20file%20is%20not%20online.%20Its%20in%20the%20desktop.%20Unfortunately%20that%20is%20not%20the%20issue..I%20read%20so%20many%20forums%20and%20tried%20to%20resolve%20this%20but%20cannot.%20This%20happens%20to%20us%20once%20a%20month%20and%20its%20really%20making%20excel%20unreliable%20for%20us.%20I%20hope%20there%20is%20some%20sort%20of%20a%20solution.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3477156%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20or%20Library%20Not%20Found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3477156%22%20slang%3D%22en-US%22%3EThe%20file%20does%20not%20have%20to%20be%20online%2C%20it%20just%20has%20to%20be%20opened%20and%20saved%20again%20with%20Excel%20for%20Web.%3C%2FLINGO-BODY%3E
Contributor

This is a continuous problem for us.  Not sure what is causing it but we get the error once a month and we have to recover our file from backup.   Excel does not allow us to interact with the Tools and References in the developer window.  It does not show any code and it does nto allow us to click on any of the modules.  Its like ti completely blows up the VBA code. 

Our normal process is to recover the file but if we accidently forget to click the backup button.  It makes things inefficient.  I know sometimes its a missing reference but this just happens randomly without warning.  Are there any steps I can take to fix this or overide without backup?

 

This is a real bummer.  Maybe one of you experts out here has seen this.

 

VeeExcelLearn_1-1654603950409.png

 

 

3 Replies

@VeeExcelLearn 

I'm not an expert, but it could come from Excel Online.
If someone opens this in Sharepoint/web/OneDrive/hard drive in Excel Online and then saves it and makes it available to everyone again, all the macros are no longer available.

Since Excel Online doesn't recognize VBA, it removes that as well.
Sometimes it also happens through the preview window in sharepoint or web, where some user does it automatically click and the file opens...with the indicated problem, in your sent image. Perhaps someone is working with Excel for the web and is causing this unknowingly.
Something like this could also be caused by team use, since when sharing the Excel file, the team perceives and edits the file as Excel Online.

As I said, I'm not an expert and all of this is without guarantee :).

 

Hope that helped maybe...if not please just ignore

 

NikolinoDE

I know I don't know anything (Socrates)

This file is not online. Its in the desktop. Unfortunately that is not the issue..I read so many forums and tried to resolve this but cannot. This happens to us once a month and its really making excel unreliable for us. I hope there is some sort of a solution.
The file does not have to be online, it just has to be opened and saved again with Excel for Web.