VBA objects or libraries missing

%3CLINGO-SUB%20id%3D%22lingo-sub-1495609%22%20slang%3D%22en-US%22%3EVBA%20objects%20or%20libraries%20missing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495609%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20my%20workbooks%20have%20lost%20contact%20with%20the%20VBA%20modules%20overnight%20All%20worked%20day%20one%2C%20but%20when%20I%20opened%20the%20file%20day%202%20it%20did%20not..%20The%20modules%20are%20still%20listed%20in%20the%20structure%20tree%2C%20but%20the%20contents%20cannot%20be%20retreived%20-%20only%20a%20grey%20shadowy%20frame%20appears.%20After%20reviewing%20the%20issue%20in%20the%20help%20pages%2C%20I%20tried%20looking%20for%20missing%20references%20-%20but%20the%20listbox%20under%20Tools%2FReferences%20does%20not%20show%20at%20all.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20other%20workbooks%20works%20as%20expected%20on%20my%20computer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20friend%20tested%20to%20open%20the%20seemingly%20corrupt%20file%20on%20his%20computer%20-%20worked%20just%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20on%20how%20to%20remedy%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2FPer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495609%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
Occasional Visitor

Hi,

 

One of my workbooks have lost contact with the VBA modules overnight All worked day one, but when I opened the file day 2 it did not.. The modules are still listed in the structure tree, but the contents cannot be retreived - only a grey shadowy frame appears. After reviewing the issue in the help pages, I tried looking for missing references - but the listbox under Tools/References does not show at all. 

 

All other workbooks works as expected on my computer.

 

A friend tested to open the seemingly corrupt file on his computer - worked just fine.

 

Any suggestions on how to remedy this?

 

//Per

1 Reply

@Per_Eskilson  I have experienced the same issue.  I will add some additional information to see if that helps in finding a solution.  My Excel spreadsheet contains several macros and when the object library is missing, I do the Alt F11 and click on tools and then references and the box either doesn't pop up at all or when it does it is completely empty.  I do save my workbook on my NAS.  The only way I can repair it, is to restore an earlier version and then manually populate the missing data, save it over the latest version and I am good to go, for a few days till it happens again.  I decided to start saving it on my local C drive to see if the problem is somehow related to the NAS.  The file size of the workbook is 90MB.

 

I will update this post if the problem occurs again with it on my C drive.