Forum Discussion
VBA objects or libraries missing
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.