Forum Discussion
heylookitsme
May 11, 2021Iron Contributor
Excel Performance Issues and Errors when PC Usage is high
I have been using Excel for over 25+ years and consider myself an expert. Excel cannot handle complex formulas and big data. Even without volatile formulas Excel can't handle much of anything you thr...
heylookitsme
May 27, 2021Iron Contributor
So, I finally think I have Excel's issues all figured out. I have been noticing when Excel starts using about 2-2.5gb of ram is where issues start occurring where Excel does all kinds of crazy stuff. I have a 16gb ram installed and one would think MS Office/Excel could easily run off of that. I have seen several posts in many other forums where users are finding the same issue at the same ram level. I am using Office 365 Apps for Enterprise 64-Bit. So, I should be able to utilize more than what it is limiting me too. I am on the most current version. So, after I completed an Online Repair I still get the Can't find project or library error when I open any file, even a blank brand new spreadsheet. My Reference Library is showing 2 Visual Basic For Applications checked one is pointed to Excel.exe and the other to the appropriate MSO.dll file. Since the one is connected to Excel.exe I can't remove it from the library. I do not want to do a full new install either. There has to be a way to access the reference library and remove this through the registry or something similar.