Forum Discussion
Recovery of personal.xlsb lost on Excel update.
10 days ago I changed from Office 2016 to O365. Is there anyway to recover my former personal.xlsb file that was lost in this process??
9 Replies
- The file should still be there. It is normally located in a folder you can reach by typing this into Windows Explorer's address bar and pressing enter:
%appdata%\microsoft\Excel\XLSTARTWhen 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?
- All I can think of is hopefully a backup?
