Forum Discussion
Excel Macros disappear from xlsm file
Hello @ PeterNagy
I understand that English is not your first language and I do appreciate you trying. I wished I could reply in the Hungarian language, but such is our World! Having this out of the way I wanted to ask you:
A) What happens if you restart the computer after each crash? For example, if you are working and suddenly the computer crashes, INSTEAD of going back to work, you take a moment and do a SECOND fresh RESTART and then continue with the work you were doing. (One Restart for the computer crash, and a second another RESTART just to clear the bugs out of the system)
B) If MS-Excel workbooks are corrupted they can behave in unpredictable ways. Try and find a clean copy of the workbook at work from this "clean" copy. If you do not have a better workbook, try and use the "Open and Repair" option with the workbook that will open.
C) "when there was a VBA code for saving a file, suddenly the macro stops at this VBA line (nothing has changed in this file and as mentioned it is working since 5 years without any problem). " Can you post the line of code and are you sure the path and folder where the workbook file is being saved is correct?
Let us know how things progress and maybe we all can learn some new things.
G.
Hi GeorgieAnne
thanks a lot for you answer. Just today I have sent out an all staff email, that in case of crash of Excel a restart of the computer has to happen immediately.
But anyway Excel is behaving strange in the last days (I am not really following up when there is an update in the background - e.g. I have realized just a few days ago that the appearance of linked excel files pop up window has been changed) and as mentioned we have never experienced such crashes before and it looks like it happens with xlsm files and not with xlsx. But I really hope that this is just a transitory period.
It would be interesting to know if such issues have popped up in case of other users more frequently these days or not
But for sure I will give a feedback in this chat
Cheers
Peter
Hi, thank you for Sharing the Excel Macro problem started in December Excel Version 2311. I have also struggled with it for almost a month. But I think I might have found a solution? well, Microsoft might have solved the problem:
On 5 Jan 2024, I uninstalled and reinstalled Office 365, and made sure Excel is updated to latest version 2312 (released on January 04) - https://learn.microsoft.com/en-us/officeupdates/current-channel
And since then, I haven't had Macro enabled Excel crashed and Macro disappeared.
I schedule update a couple of Macro Enabled Excel files every 30 mins, and since Friday, it still update fine.
Just want to share this with you guys.
Cheers
JazzTea Can you advise if you are still issue free? We are experiencing the same issues on a daily basis. If this fix seems to work, I will get the upgrades done as soon as possible. We have over 60 users in macro enabled excel everyday.
Hi I just can confim that with the 32bit version everything was fine. I have reinstalled the 64 bit version just a few days ago, so I have no final conclusion on this
Cheers
Peter
- Hi,
thanks for the info. We have update our office version as well two days ago. Since then we have not experienced the big crash. BUT when we are working with excel files with macros then we get a message like there is some problem with your excel.. (we get it in Hungarian due to that I do not know the exact words in English for this message and there is no error number). Then I try to save as the file and get the answer that are problems with saving the file and I get the information that the file can only be save with minimal function in an XLSB format ... and then I get the message that the file has been damaged seriously, excel has tried to save data and formulas, but it may happen that there is a data loss...
I such case what I can do that I go back to my daily backups and take the saved file from the last day and start the work again.
So the trouble goes on and we still start everyday with a fear when opening excel and asking ourselfs what will happen today.
It would be great if Microsoft would be a little more transparent of the processes happening in the background (OK it can happen that they also do not know the reasons...)
Cheers
Peter- Yep, this is the exact issue I'm experiencing still. Going back to an earlier backup is a workaround but it definitely hinders daily productivity. I too wish that Microsoft would at least acknowledge this issue.
- Please keep us all posted on this. While I'd like to believe that Msoft resolved this with the update, I'm hesitant to believe that.
Unfortunately, they haven't and it soooo obviously related to one of the recent builds. I have Version 2401 Build 16.0.17231.20194 that just came out on 2-1-24. Been using this very simple macro for years and now the macro doesn't show up in the Macro list and when I run it from the Visual Basic button, I get:
And since MS has to know that their updates are not well QAed, why don't they automatically create a restore point before updating our computers? My fault for not turning off automatic updates, the updates need to season a couple of months before turning them loose on my computer.
