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
PeterNagy's avatar
PeterNagy
Copper Contributor
Dec 19, 2023
Hi,

no, final answer yet. But I have realized that one of our xlsm files (our timesheet file, which is running on each computer) is generating this problem most frequently (this file is started by the task scheduler on hourly basis). In this file we hade a macro which was running automatically when the file has been opened. I have cut out this macro and since then we have experienced this problem less. But there was no science behind this step and it is absolutely possible that there is no link at all and it was just pure luck.

Cheers

Peter
KCU_123's avatar
KCU_123
Copper Contributor
Dec 19, 2023
Thank you Peter for your updating and sharing your findings. This problem is really frustrating and really a headahe for me. 6 out of 10 items I run my reports and they crash and I cannot save the files and all my macros are missing. I hope microsoft can produce a quick solution to this. Kind regards, Kebin
  • JoaoBJ's avatar
    JoaoBJ
    Copper Contributor
    Dec 20, 2023

    I have been experiencing something akin to that.
    Several of my xlsm files have lost their connection to its macros or, worse, loose all their macros like if it was not a xlsm file.
    One day the macros run without a glitch, and I save them. The next day, I open the file and when I press alt+F8, there are no macros to be executed. Or if I press the keys associated to run a macro, nothing happens. Then, when I press alt+F11, one of to things happen: there are no modules anywhere to be found or, if there are any, when I go to one of them and press F5, I get an error message:

     

    The first time this happened I thought that it was one of those pesky things that happens from time to time with Excel and safe mode, and just got a backup file and restarted. The second time around, I did the same thing. The both times that this happened it was with large Excel files and I thought that may be it was related to their size. Today it happened with a pretty small file so it is not size related. And this started happening after an office update. So, it probably is a new error that needs to be addressed.

    • NicolasTld's avatar
      NicolasTld
      Copper Contributor
      Dec 20, 2023

      Hi,

       

      I have no solution to give you but I can guarantee that this issue is not a new one. I'm facing it with all kind of file's size since at least 2019 (I've tried hard to find any related characteristics between corrupted workbooks but sadly there's not).

      • PeterNagy's avatar
        PeterNagy
        Copper Contributor
        Dec 21, 2023
        Hi Nicolas,

        you are right that there were problems before as as well, but somehow since a few days this is on a new level. As mentioned before I have requested my whole staff to do a restart of the computer in case they experience any strange happening during the opening of an Excel file. Other sign when I have asked for a restart if they are opening an Excel file and they get a message that Personal.xlsd file is in use due to that it can be opened in read only version, but actually we are not aware of any other oper Excel application - so there is no explicable reason for the read only opening. Since we have issued this restart startegy we had no loss of macros. But I think this is not the way it should go.... So we are desperatley waiting for any improvement

        Cheers
        Peter

Resources