Forum Discussion
VBA 2023 update
I'm having the same problem after the January update with a workbook that I've used for well over 3 years without issue.
And same as you, I found that editing the code would temporarily fix the issue until the workbook was closed and opened again. Oddly, I have several workbooks with macros (one being very similar to my problem workbook) and those all work fine.... it's only the one that has trouble.
I don't have a fix but have found 2 workarounds so far that at least allow us to keep using the workbook....
I found that if I rename the file, Excel no longer recognizes it as a Trusted Document. If I click enable macros each time I open the workbook but do not make it a trusted document, everything works. As soon as I try making it a trusted document again, the issues return.
The second workaround that I found is rolling back the O365 update to version 15831.20208 (the last version from 2022). Once I did that, everything worked fine just like it had been for the last 3 year.
Hi Matt, thanks for your reply.
In one way I'm glad that someone else is having this same issue so hopefully Microsoft see this and can fix the issue. But this is still a very annoying issue.
Unfortunately your 2 work arounds haven't worked for me.
The 'trusted document' method looked promising as I read it, but it didn't work. (I can't actually change the file name without the file working, so I made a new file with the same name which still gives me the trusted document prompt)
And our IT department have tried rolling back the update, but the issue is still there. I think if we spent more time trying to roll back the update it would work, but the process looks very complicated and we might not be doing it correctly. Also, moving forward it probably isn't ideal.
One strange thing I noticed is I needed to make a small change to the file and when I saved/overwrited the file, the file size increased from 2.5mb to 3.0mb.
I looked deeper into it and found that if I opened the original 2.5mb file, and saved it without doing anything, the file size still increased to 3.0mb
For the moment my best option is to edit the code when I open the file. Thankfully only one other computer in our office has done the excel update, so I have paused excel updates on all the other machines.
Thanks for your replay Matt. Appreciate it.
If you come up with any other solutions, please let me know.
Thanks
Tom
I have just discovered that when I open the file and get it to work by editing the VBA code, I can change the code back to it's original and it works.
What have you done Microsoft?!