Forum Discussion
Lost Macros
Hi, I was speaking to a tech support person in chat and they sent me here after poking around on my computer. I have lost my Macros in EXCEL 365 twice. The first time Excel froze and I had to start excel. the second time was last night. There was some sort of update on my computer over night. It didn't seem to affect Excel as I was able to continue working on it this morning. But when I went to apply a macro they were all gone. I am not very tech savvy but I read something that said it could be retrieved if I went to a folder called XLSTART but when I went there the folder was empty. I want my macros back as they took hours to make and get them right. I also want to ensure that this won't happen again. I am not sure if antivirus software has anything to do with this. I just know I never had this problem with older versions of excel. PLEASE HELP! I can't get any work done if I am constantly trying to rewrite macros.
2 Replies
Hello AvidTourist!
Looks like your macros might not have been saved in the correct location or could have been affected by the update. First, try checking the folder where Excel stores macros, which is usually in a specific file location on your computer. If they’re not there, you might want to see if any previous versions of the file are available by checking the "Recover Unsaved Workbooks" option in Excel.
To prevent this from happening again, make sure you're saving your macros in your personal macro workbook or a specific location that won’t be overwritten during updates. You can also back up your macros regularly. If you're using antivirus software, it’s a good idea to check if it's blocking or interfering with Excel’s functionality. Hopefully, this will help prevent future issues.
I hope it helps!
If they were not in the right place when they were visible and working why did they work before the upgrade to windows 11?
