Forum Discussion
Personal.xlsb Workbook Keeps Opening
Every time I open Excel, the Personal.xlsb workbook opens. It did not used to do that. Anyone know how I can prevent it from opening?
Don
20 Replies
I was having this issue with M365. I had saved a MACRO to Personal file, but ultimately removed the MACRO - Personal still kept auto-launching for no reason, and causing an additional Excel window to launch (blank, but not a blank workbook). Ultimately I searched for PERSONAL.XLSB and deleted the file and it no longer launches.
Ensure that your workbook is not accidentally actually saved as "Personal.xlsb.xlsm"
By default, windows hides file extensions, so you might see "Personal.xlsb" under the File Name field, but the true file type is actually some other kind of excel file (.xlsm, .xlsx, etc). I made this mistake when I accidentally forgot to choose "Excel Binary Workbook" type in the Save As... dialog when saving my Personal.xlsb.
In the Detail view of File Explorer, it should say "Microsoft Excel Binary Workbook" under File Type for Personal.xlsb. If it says anything else, you need to open it and Save As... to select a different file type.
After saving Personal.xlsb as the correct file type, I opened it back up. Go to View-->Hide to hide the Personal.xlsb workbook. Close and save. Now when I open excel, it has normal startup behavior (Start Up screen or an empty workbook depending on which options are selected).
At any time you can go to view-->unhide to see the personal.xlsb workbook and edit it.thank you this really helped me out! I had unhidden the personal workbook to delete a macro, and couldn't figure out how to hide it again. 😂
How do you insert column breaks in exel?
Since your question is completely unrelated to the topic of this discussion, you should have started a new one.
But Excel does not have column breaks, unlike Microsoft Word.
In Cell A1 have a 5 and in Cell B1 have a 10 and in Cell C1 formula =sum(A1*B1) which it multiplies out corectly to 50; Now in cell D1 want to multiply C1 x D1 or 10 and because a formula is in C1 it will not work....how do I make a cell with formula work when multiplying by another cell with a number in it.
Ia both cells have formulas in them is that a way to multiply both of them?
This thread is about Personal Workbooks used for Macros opening, but what you are describing works as expected.
I am suffering the same thing. Since Excel opens a new instance each time, and not just a new book, it's also opening the personal macro workbook, saying it's already in use and if I want to open it as read only or be notified when it is available.
This is extremely tiresome as I use macros and multiple files a lot.
Hi Adam, I am getting this, and I agree its very frustrating. Did you manage to get a fix?
for me its when I open an excel file from different locations ie oneDrive, SharePoint, local drive etc
Jones-SiGSame here - it happens when opening a Teams file, OneDrive, or SharePoint online file in the desktop version.
Hi Don,
When you open Excel select the Personal Macro Workbook and go to:
View >> Window >> Hide
After that, close Excel, and you will face a message asking you to save the changes you made to the Personal Macro Workbook, click Save.
Worked, thanks!
Thanks! It Works!
Haytham Amairah you rock!
