11-23-2020 08:09 AM
11-23-2020 08:09 AM
I am using the latest version of Microsoft Office 365 ProPlus where I created a Dashboards of sorts in .xlsb format. Which I use all of the time without problems. This file has worked great up until today. When I open it I receive an error stating "Can't Find Project or Library". I do no know this is referencing a missing Reference file in VBA but when I open the VBA Editor the windows become frozen in the editor and no codes are visible. When I select Tools Reference nothing happens. I have had this happen on a different, unrelated file about a month ago and a quick repair fixed the issue. I just completed the repair and the issue still exist. My next step is online repair. Before I do this, I simply do not understand what went wrong, when nothing changed. Is there a fix for this that someone could let me in on. Everyone here knows how critical it is that when presenting data to clients, that in order for them to have confidence in your data it must be correct and without error. Well it just so happens that when I was presenting this in a meeting today is when the file decided to go haywire. My company is beginning to invest heavily in AI software and once again this does not look good on me or Excel. It just bolsters up AI Software even more (which will eventually replace us data analysts). I know the folks at Excel are working hard so, I am not miffed at them but Excel has got to get better. I have so many examples of this type of stuff happening more often than not. Not just me but my other Data Analysis partners as well. Excel needs to hire some of its old school retired programmers back and sort the messes out and teach the new programmers.
11-23-2020 08:58 AM
@heylookitsme Further Investigation (opened in Safe Mode) allows me to open and select all of the data in the VBA Editor (which I quickly saved to word). Tools, Reference shows 5 Checked Ref Files: out of those 5 files the Locations of them are accurate and good. No Blank or unusual file references showing. However, when I view the Object Library Window there is a selection for VBAProject which is not listed in my Library Reference and the location of the file is showing the same as this file with this file being its reference. So, this is what is causing the error. Now how to remove a Reference Library that is not showing in your Refence toolbox and how to locate and add the VBAProject Reference so it can be added back into the reference library from the correct location.
11-23-2020 09:08 AMSolution
@heylookitsmeSo for anyone with this issue here is the fix: I opened tools and selected VBAProject and then changed the name to something else. This caused it to drop that bad file reference object that was just pointing back to the same workbook. Not sure how it happened.