Forum Discussion
Who are the Moderators? Anybody read this? VBA Macros are Broke, Formulas up 30% Slower.
I run in Office365, Excel for Office 365 MSO 16.0.12130.20232.
Created a macro in VB in 1999 (Excel 1997) that has run perfectly since, in a spreadsheet processing through 126 VLOOKUP tables in micro seconds. Until the last month or so when the macro slowed to a crawl and in a spreadsheet with a .xlsm file extension, will not run when initiated with keyboard shortcut keys.
In the August 30, 2019 KB4512941 update (OS Build 18362.329) for Windows 10 Version 1903, under "Improvements & Fixes", Non-Security update, is this statement:
"Addresses an issue that may cause the following to stop responding:
Applications that were made using Visual Basic 6 (VB6).
Macros that use Visual Basic for Applications (VBA).
Scripts or apps that use Visual Basic Scripting Edition (VBScript).
You may also receive an "Invalid procedure call” error."
For some reason, this update did not install and will not install today, but issues the statement that "The update is not applicable to your computer"
What I know is that something in a Windows update messed with the operation of VB and there appears to be a fix in KB4512941 that can't be downloaded. If this update is not applicable to my computer, is there another way to get the fix?
- JKPieterseNov 14, 2019Silver Contributor
Tip to anyone reading this thread.
Microsoft does "listen" to feedback through the File, Feedback, send a frown button in any Office app.
So if you're experiencing slow calculation on a workbook which has not been changed and worked perfectly fine some time ago, take these steps:
- Create a screen-shot of your Windows version information (hit the windows button, type "version" without the quotes and run System Information):- Insert that screenshot into a blank spreadsheet and make sure it fits on-screen and is still readable
- Click File, Feedback, Send a frown
- Enter your concern in the top box
- Check the include screenshot box (hence pasting the screenshot of system info on Excel so it is included!)
- Decide whether you want to include contact information and diagnostics and usage data
- Submit.
I do encourage everyone with any Excel issues to use this feature.