VBA 2023 update

Matt Colosky 

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