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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-03-01T13:50:56+00:00

    I am experiencing an issue with the personal.xlsb file on my machine. Yesterday I was trying to get a macro to work so it would load the date automatically when the file was saved, and after that failed to work, I deleted its contents from that file.

    Now, whenever I open Excel, I am automatically warned about the security notice - enable/disable macros. It shows a string of folders on my machine to the personal.xlsb file; however, I am not able to find it no matter what I do.

    I have accepted the macros, and I have also declined the macros, and then I go to Developer » Macros, and nothing is listed as I removed the failed attempt earlier. But I still get the warning no matter what I do.

    Does anyone happen to have any useful suggestions as to what I should do to resolve this?

    Many thanks for your help!

    Record a new macro (doesn't matter what's in it) in order to afterwards be able to edit it in the visual basic like code writing environment. Then delete all modules under personal.xlsb, and click save and exit. Hide personal.xlsb and close down Excel, click save if asked.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-02-23T18:54:00+00:00

    I am having the same issue, this is what I did, I saved the macro file with a different name in a different folder. 

    Went the folder where the PERSONAL.XLSB is stored. for you it should be like

    [C:\Documents and Settings\XXXXXXXXX\Application Data\Microsoft\Excel\XLSTART\

    I deleted this file and now I am no more seeing the file at all.

    I was able to open the excel and see Book1.xlsx loaded.

    Try this, if it helps, it did for me...

    Good luck.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-11-03T23:31:04+00:00

    Thank you for your post.

    all done.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-09-08T22:15:01+00:00

    Brilliant - this has solved the problem.

    Many thanks.

    Was this answer helpful?

    0 comments