Forum Discussion
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...
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
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
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