Forum Discussion

PeterNagy's avatar
PeterNagy
Copper Contributor
Dec 14, 2023

Excel Macros disappear from xlsm file

Hi,   since a few days we are experiencing the following on several computers (we are O365 customers and Excel is always update automatically (Version 2311 build 17029.20068) with Excel:   We are...
excel
Macros and VBA
GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
Dec 14, 2023

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.

  • PeterNagy's avatar
    PeterNagy
    Copper Contributor
    Dec 14, 2023

    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

     

     

    • JazzTea's avatar
      JazzTea
      Copper Contributor
      Jan 08, 2024

      PeterNagy 

      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

      • MLoya168's avatar
        MLoya168
        Copper Contributor
        Jan 08, 2024
        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.

Resources