Forum Discussion
Who are the Moderators? Anybody read this? VBA Macros are Broke, Formulas up 30% Slower.
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
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."1. Uninstalling Office completely and re-installing resolved the issue with VBA. However, it wouldn't uninstall normally and I had to use the Microsoft Support and Recovery Assistant to uninstall it, then restart and re-apply my license. Of course Office didn't remember this was the same computer and the same Microsoft account, so license had to be entered again. I guess all the users affected by whatever patches were issued since the end of October will have to uninstall Office and re-install again?
It's still the same (broke) on my other machine for which I have not re-installed Office. This almost seem pre-meditated scheme to clean out and profit on all those 5 user licenses you sold and then revoked by making them buy new licenses for the ones you are revoking? Again, of course your Office Microsoft account doesn't remember the licenses for non-365 users.
2. The issue with Formula speeds still exists the calculation time on 250,000 rows on an AMD 3700X has increased from 74.x seconds to 124+ seconds. Did the OS or Office issue a bunch of CPU fixes for ZombieLoad2, Spectre, Meltdown for the other Intel CPU issues that affects all CPU's. Again, both Intel machines and AMD machines calculation times have slowed significantly.
Summary, 1 of 2 issues (brute force) fixed and one more Microsoft license forcefully sold and Office is much slower to boot. One flagrant violation can be overlooked (changing the $$$ terms MS sold Office at, after the fact), but multiple issues and a slower Office with 2019 high-end hardware; it's not a joke, but I wish it were.
P.S. Afterthought, you could just look at it this way, if you bought the Microsoft HUP License, Features have been revoked or removed. If you need advanced features you paid for now, you will have to buy the another, new single PC license or Office365. Just wow . . . the gall.