personal.xlsb opens when opening a new file

Anonymous
2010-08-03T14:16:56+00:00

The file personal.xlsb opens every time I open a new file. I saved all my macros in module1 of the new workbook but this personal file keeps opening. I have read that in Excel > Options > Advanced > under General, At startup open all files in is = BLANK will stop this but mine was already BLANK. How do I stop this file from opening?

Thanks,

JCM

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-08-03T14:59:33+00:00

Hi,

Persaonal.xlsb opens automatically every time Excel opens provided it has been created.

Writing a UDF wouldn't create P.xlsb unless that UDF was saved to P.xlsb. So at sometime; and maybe no associated with this UDF, someone has saved something to P.xlsb (maybe in error) and caused the creation of that file.

Now it is created I strongly recommend you hide it and forget it but if you don't want to do that then you can delete p.xlsb like this.

With the Excel application not running.

Open windows explorer, and assuming you did a standard installation, navigate to

C:\program files\microsoft office\office 12\xlstart

delete personal.xlsb

If this post answers your question, please mark it as the Answer.

Mike H

Was this answer helpful?

90+ people found this answer helpful.
0 comments

43 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-04-24T15:46:51+00:00

    Thank you for an answer that actually works!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-06-03T12:10:08+00:00

    Run this code in the VBA Editor:

    Sub WheresTheStartupPath()

    MsgBox Application.StartupPath

    End Sub

    My path was

    C:\Users\Jerome\AppData\Roaming\Microsoft\Excel\XLSTART

    Close Excel.

    Go to that path and delete any files in this folder (or move them to the desktop to ensure nothing breaks permanently). 

    Restart Excel.

    This worked for me in Excel 2013.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2014-07-11T20:13:57+00:00

    Thanks for the answer. 

    One thing I've noticed about "tech" people (especially on this site) is that they always choose the long answer with their techno babble.  Making thing more complicated than they really are.

    Some tech people are so used to working with machines, that they can't identify with people anymore.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-12-10T08:46:07+00:00

    Thanks for your hint.

    For my case, the pathname is C:\users\name\AppData\Roaming\Microsoft\Excel\XLSTART.

    Windows 7 home premium

    Microsoft Office 2010.

    Windsor

    Was this answer helpful?

    0 comments