Home

"Can't find project of library" error with latest Insider update

%3CLINGO-SUB%20id%3D%22lingo-sub-811287%22%20slang%3D%22en-US%22%3E%22Can't%20find%20project%20of%20library%22%20error%20with%20latest%20Insider%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811287%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20today's%20Excel%20Insider%20update%20I%20get%20the%20error%20%22Can't%20find%20project%20or%20library%22.%20Normally%20this%20means%20that%20I%20need%20to%20go%20into%20the%20Visual%20Basic%2FTools%2FReferences%20dialog%20and%20make%20any%20corrections%20but%20after%20this%20update%20the%20References%20dialog%20no%20longer%20appears.%20This%20is%20true%20only%20after%20a%20document%20that%20has%20a%20problem%20is%20opened%2C%20even%20when%20opening%20in%20Safe%20Mode.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDocuments%20that%20don't%20use%20this%20unknown%20reference%20don't%20cause%20the%20error%20and%20I%20can%20open%20the%20References%20dialog%20whenever%20a%20document%20that%20doesn't%20use%20a%20missing%20reference%20is%20opened%2C%20but%20I%20can't%20open%20the%20References%20dialog%20when%20there%20is%20a%20bad%20reference%20in%20the%20Excel%20and%20therefore%20I%20can't%20correct%20the%20problem.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20other%20way%20to%20open%20this%20dialog%20for%20a%20particular%20file%2C%20or%20is%20there%20some%20way%20I%20can%20read%20what%20references%20are%20expected%20in%20a%20given%20file%20and%20install%2Freinstall%20them%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-811287%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-811303%22%20slang%3D%22en-US%22%3ERe%3A%20%22Can't%20find%20project%20of%20library%22%20error%20with%20latest%20Insider%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811303%22%20slang%3D%22en-US%22%3E%3CP%3E%40%20found%20that%20I%20was%20able%20to%20open%20the%20file%20that%20was%20causing%20this%20error%20on%20a%20Macbook%20and%20in%20that%20version%20of%20Excel%20I%20was%20able%20to%20save%20the%20document%20and%20edit%20the%20References.%20I%20was%20able%20to%20reestablish%20the%20proper%20references%20and%20reopen%20it%20in%20Windows%2FExcel%20without%20the%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20still%20exists%20however%20that%20whenever%20there%20is%20a%20failure%20to%20the%20references%20in%20Windows%2FExcel%20that%20users%20may%20not%20be%20able%20to%20open%20the%20VB%2FTools%2FReferences%20dialog%20and%20fix%20the%20problem.%20I%20suspect%20that%20not%20everyone%20has%20both%20a%20Macbook%20and%20Windows%20platform%20to%20work%20around%20the%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811393%22%20slang%3D%22en-US%22%3ERe%3A%20%22Can't%20find%20project%20of%20library%22%20error%20with%20latest%20Insider%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F222500%22%20target%3D%22_blank%22%3E%40Chris%20Charette%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%2C%20but%20perhaps%20this%20bug%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.computerworld.com%2Farticle%2F3431699%2Fmicrosoft-warns-of-visual-basic-vba-and-vbscript-procedure-call-errors-after-august-patches.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.computerworld.com%2Farticle%2F3431699%2Fmicrosoft-warns-of-visual-basic-vba-and-vbscript-procedure-call-errors-after-august-patches.html%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Chris Charette
New Contributor

After today's Excel Insider update I get the error "Can't find project or library". Normally this means that I need to go into the Visual Basic/Tools/References dialog and make any corrections but after this update the References dialog no longer appears. This is true only after a document that has a problem is opened, even when opening in Safe Mode. 

 

Documents that don't use this unknown reference don't cause the error and I can open the References dialog whenever a document that doesn't use a missing reference is opened, but I can't open the References dialog when there is a bad reference in the Excel and therefore I can't correct the problem. 

 

Is there any other way to open this dialog for a particular file, or is there some way I can read what references are expected in a given file and install/reinstall them?

 

2 Replies

@ found that I was able to open the file that was causing this error on a Macbook and in that version of Excel I was able to save the document and edit the References. I was able to reestablish the proper references and reopen it in Windows/Excel without the error. 

 

The problem still exists however that whenever there is a failure to the references in Windows/Excel that users may not be able to open the VB/Tools/References dialog and fix the problem. I suspect that not everyone has both a Macbook and Windows platform to work around the issue.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies