Forum Discussion
Recovery of personal.xlsb lost on Excel update.
When I started Excel after it was "reinstalled" I started the program, activated the developer tab and looked for my macros. They were not there and personal.xlsb did not show up as a possible location in the Excel macros selection window. I closed Excel and tried File Explorer but it could not find XLStart or personal.xlsb in my Windows 10 user folder. I started Excel again, created a simple macro in personal.xlsb, closed Excel (and saved personal.xlsb). The personal.xlsb file now exists in appdata\roaming\microsoft\Excel\XLStart and is easily located by FIle Explorer. This new personal.xlsb file contains only the simple macro I created above.
Any idea where I might find my old personal.xlsb file so I can get my macros back?
Ok. Thanks.
Assume the previous MS Office applications had become corrupted (which is what I was told and prompted the tech to refresh O365) is there any way to reinstall/refresh the Office applications and not lose the existing options and configurations like the personal.xlsb files? Should I have expected the xlstart folder to disappear when I re installed / updated O365?
Thanks.
- Normally the XLSTART folder remains untouched on a reinstall of Office, but if they used some tool to thoroughly remove a preextisting installation it may very well have removed that folder. In future, I would just not use personal.xlsb but rather a workbook saved in a folder somewhere so that it is included in your companies backup schemes.
I like your suggestion about using a different file.
Since the Excel installation did not go as planned and may have been incomplete, do you think it would be wise to just remove this installation of O365 and do a clean install?
Thanks for all of your help.