Forum Discussion
Macro-Enabled Workbooks not working.
Hello all, I've recently started to see more issues with macro enabled workbooks within our work unit. We are on Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20140) 64-bit...
I am facing the same issues for quite a while now. I maintain approximately 50 macro enabled "tracking files" all of which use user forms, buttons and generally simple text manipulation macros.
Out of these 50 file, each month I see a random 3-5 files experiencing the same errors randomly without any known logic or cause.
List of issues: code seemingly disappearing, file crashing on open, file crashing on button press / user form activation
Only solution that works on my end is using the file open option: "Open and Repair" after doing it and saving the repaired file, it works as nothing happened...
On top, since feb. I noticed significantly longer macro runtime comparing to previous 3 years of using the same macro... Macro that used to take 3 cells and work with their values in milliseconds now takes up to 10 seconds to do the same, without any modification.
Out of these 50 file, each month I see a random 3-5 files experiencing the same errors randomly without any known logic or cause.
List of issues: code seemingly disappearing, file crashing on open, file crashing on button press / user form activation
Only solution that works on my end is using the file open option: "Open and Repair" after doing it and saving the repaired file, it works as nothing happened...
On top, since feb. I noticed significantly longer macro runtime comparing to previous 3 years of using the same macro... Macro that used to take 3 cells and work with their values in milliseconds now takes up to 10 seconds to do the same, without any modification.