How to Stop Personal.xlsb from Opening in Excel

If you’ve created a macro in Excel, you may have noticed that a workbook called Personal.xlsb keeps opening whenever you launch Excel. This is annoying, but depending on your system’s set up, completely necessary. Personal.xlsb is where the macros that you’ve personally created are stored, and it differentiates your Excel macros from any scripts or extensions that your organization uses. That being said, if seeing Personal.xlsb every time Excel launches bugs you, you can hide it. Here’s how.

Hide Personal.xlsb when Excel Launches

By default, Personal.xlsb will be hidden when Excel launches. Chances are, it’s been there a lot longer than you realize. But for one reason or another, it can become unhidden.

The quickest way to get rid of it is to go to the View tab and click Hide.

Now, Personal.xlsb will continue to open but it’ll be hidden from view. In this way, you’ll still have access to the macros you’ve recorded, but you won’t see that pesky Personal.xlsb window anymore.

You should know that this file is normally stored in the C:\Users\[yourusername]\AppData\Roaming\Microsoft\Excel\XLSTART folder.

In fact, anything you place here will open automatically when you launch Excel.

In theory, another way you could get rid of Personal.xlsb is to delete it from this folder. But then you’d be losing the macros that you’ve saved. You can view your macros from the Developer tab in Excel.

If this entire time I’ve been talking about macros you’ve had no idea what they are and why you’d need them, then you can probably safely delete Personal.xlsb from this folder. But if you’re on a work computer or if you ever use macros to automate tasks, I might just leave it be and hide it just in case.

Are there any other little Excel nuisances you’d like help with? Drop us a line in the comments and we’ll look into it!




  1. Lynyker  

    Thank you!!! Helped a lot, kind of obvious, but when this bugs you, you lose it!

  2. Jeaux  

    I’m having an issue with this. I can’t hide my Personal.xlsb. Every time I try Excel crashes again. I can open old workbooks, but I can’t create any new ones. HELP.

  3. Kristen  

    This worked perfectly for me. Thank you very much.

  4. Robert J. Pottle  

    Thank you for your advice. This worked great, but one additional step is needed. When you close the opened primary file, you must click Save. Otherwise, the .xlsb file will continue to appear.

  5. Michael Leo Pitre  

    Thank you for the post. That solved the issue by copying the C:\Users\[yourusername]\AppData\Roaming\Microsoft\Excel\XLSTART and deleted the file.

  6. Pesche  

    Thanks for the hint, but this does not work for me. When I hide Personal.xlsb and try to close Excel, it automatically unhides itself probably as a result of the saving dialogue. Any workaround for that? (Excel 2010)

  7. Marta  

    Excellent! Very good advices to solve this matter.
    Thanks a lot!

  8. Marianne Germain  

    Such a time (and energy) saver :)
    Thank you so much!!

  9. Laura T  

    This has been plaguing me. Thank you for the clear/concise solution.

  10. Codename  

    Thank you for the help.I had important documents and needed to create new ones.I panicked since I thought it was broken but it was just unhidden.

  11. Jesus  

    Thank you! very useful!

  12. Laurent DADA  

    unable to save files to one drive. excel closes and when I restart i get this message “sorry couldn’t find HTTPS// …..”

    This started after I created a macro that I saved in file “PERSONAL.xlbs

Leave a Reply

Your email address will not be published. Required fields are marked *


To Top