•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to restore disappeared VBA Macros from Personal XLSB
Our take
If you've encountered issues with your Personal XLSB file after a glitchy restart, you're not alone. Many users experience similar frustrations when their macros seem to vanish unexpectedly. In this guide, we’ll explore practical steps to help you restore your missing VBA macros, ensuring that you can regain control of your spreadsheet tools without having to rewrite them from scratch.
Hi everyone, long story short, my computer was acting glitchy today so I restarted it. After, any workbook I tried to open would say it was "corrupt" and wouldn't open, or that it needed to be repaired. For the latter, it would say "Excel was able to open the file by repairing or removing unreadable content" which was usually sheets I had deleted from the file (so no real content missing?).
The big issue is my VBA macros are missing. I had saved all of them in my Personal XLSB. My Personal XLSB was also impacted by the issue above. It was after I repaired and saved the file that I noticed all the Macro modules are missing from the VBA editor (Alt+F11) and the macro dialog (F8). Macros are enabled in trust center, and there is no file history on the Personal XLSB. Of course I didn't back these up... :/
Interestingly, after repairing the Personal XLSB my other workbooks seem to open and run fine. No more popups stating the files are corrupt or need repair.
Does anyone know if it's possible to get the macros back? I am definitely no expert in excel or VBA so just hoping I don't have to rewrite them all...
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Personal Macro Workbook Missing on Mac OSI started working on something and all my macros are gone, and when I went to take a look at my personal macro workbook it's gone - unhiding doesn't do anything. I know I have fixed this in the past - I think it just got disabled somehow but I can't figure out how to see it in VBA or anywhere else - does anyone using excel on a mac recall how to fix this? Any help would be very much appreciated! submitted by /u/whateverbitch11 [link] [comments]
- Excel .xlsm files showing “We found a problem with some content” after savingHi everyone, Good day. I’m currently experiencing an issue with Microsoft Excel involving macro-enabled files (.xlsm) that contain VBA code and are stored in Microsoft OneDrive. Scenario: I open an .xlsm file (with VBA), make edits or even just open and save it. When I reopen the same file, I get the error:“We found a problem with some content… Do you want us to try to recover as much as we can?” Additional details: Files created in 2025 were working before, but now they are no longer working even if I did not make any changes. The issue now happens consistently even without modifying the file. What I’ve tried: Opening and repairing the file Saving as a new file Checking OneDrive sync Has anyone encountered this issue recently, especially with OneDrive syncing and .xlsm files? Any suggestions or fixes would be greatly appreciated. Thank you in advance for your help. https://preview.redd.it/wycqd6215fzg1.jpg?width=362&format=pjpg&auto=webp&s=a695ef001723887a5f9739c96e92bc21f0b5ab1e submitted by /u/Electronic-Tear-4567 [link] [comments]
- Visual Basic Error when using MacrosHello Community, we got some excel file with macros from an agency we work with. On domain users in our network it brings this error: Microsoft Visual Basic for Applications File not found: C:/users/(username)/appdata/local/temp/*.tmp Those files mostly begin with VB*.tmp This error doesn´t occur on local users / domain-admins I have already worked through all excel gpos regarding macros and safety. I have already marked the file as safe and also the network directory in which it is stored. It also will not work when saved locally with a domain-user (it only worked once) Maybe someone can help me. Thanks in advance! submitted by /u/Maleficent-School762 [link] [comments]
- Excel File reverted to previous version after power outageI had an excel file simply called "bills" that I've been using for the families accounting. I run some server stuff on the computer so its on 99% of the time. Today, the power cut out for about a minute and after rebooting the excel file got reverted to a version from November 2025. I have for sure saved the filed weekly if not daily since then, have autosave on, I have powered off the computer for updates and whatnot and reopened it and continued without problems, but now suddenly all that work has been lost. I have checked the auto recover feature, again only versions from way back last year. I've been told to check the temp files, but I'm either doing something wrong or their not excel files (made copies and trying to rename the extensions to .xls, still just jibberish). I'm freaking out because its how I budget around bills and taxes and whatnot. Its saved locally only so no cloud backups, there was another copy of it called like Bills.xlsx.xlsx but its also been reverted. I don't think I have any recent restore points either, but everything else on the computer is up to date after the power outage so I have no idea what happened. The ONLY thing that I can find that got reverted was excel, and I have no clue why or how, but urgently need to fix it. Any advice at all would be great, Microsoft support told me to kick rocks since its "Office Home & Student 2019" and therefore not their problem and I'm on Windows 10. submitted by /u/Weekly-Mushroom-2225 [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#big data management in spreadsheets#generative AI for data analysis#google sheets#real-time data collaboration#real-time collaboration#big data performance#VBA#macros#Personal XLSB#Excel#workbook#corrupt#repair#unreadable content#macro modules