Forum Discussion
Who are the Moderators? Anybody read this? VBA Macros are Broke, Formulas up 30% Slower.
RAINFIRE I've exchanged some emails with people from the Excel team and they requested this:
"can you please ask the original customer to send us a frown (as I described earlier) after using the workbook and include their email? This will provide us with the necessary telemetry info. Please also ask to include their email so we can directly communicate with them too on follow-ups"
JKPieterseYes. I've done the feedback with a frown and included my email as requested. I used same message from above.
Contact: derek moore ***@ hotmail.com
This issue is with the with the calculation timer code. In the firs MS link below there are two pieces of code. The second link is my sheet, that is producing the error, where I was using them to 1st: Calculate Formula Time and 2nd: Refresh the average run times from multiple runs. It was working up until the near the end of October, 2019. Now when I load the sheet it expels the VBA code from the sheet and gives error. I've rebuilt the sheet re-attaching the VBA code into a module and it does the exact same thing. Now this error appears every time. Title: Microsoft Visual Basic for Applications: "Can't find project or library"
https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calcuat...
https://intensewebs.com/index.php/benchmark/real-world-cpu-performance-checker-excel
- What happens if you add a new user to your machine and logon as that user, does it still fail then?
JKPieterse I enabled the 'Administrator' account for the first time, set a password and logged in for the first time as Administrator. I accepted the first time Office agreement for the user. I loaded the sheet and was asked to 'Enable Content' which I did. The exact same issue occurred with the VBA. Upon load, the VBA is expelled and the error pops up again, "Can't find project or library"
- OK, so it isn't a user account issue (I've seen it happen more than once).
I haven't got any machines with your setup, so I can't comment much more, other than the not-so-pleasant "have you tried completely removing Office and running a cleanup tool to get rid of all of its traces."