+ Reply to Thread
Results 1 to 5 of 5

Extra personal.xlsb files

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    Boise, ID
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Extra personal.xlsb files

    While working on macros I have had several computer crashes that have resulted in copies of my personal.xlsb and autorecovered versions of my personal.xlsb files to be created. I now have 4 personal.xlsb (different names such as 'copy of personal.xlsb', personal (autosaved).xlsb') that launch every time. I cannot find them to delete them. My XLSTART folder is empty but they all still lauch when I open Excel. I am not having all of them lauch rather than Book 1 when I open Excel. How do I clear these out to have a single personal.xlsb. Each of them has the personal.xlsb hidden within it.

    Because of these when I am running other programs that launch Excel I have to say read only 4 times just to open a downloaded file from my other programs.

    I am looking for a different answer than just hide them. Thanks!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Extra personal.xlsb files

    Hi

    My personal file is at address: C:Users/username/appdata/roaming/microsoft/addins

    Good Luck

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Extra personal.xlsb files

    With each personal file open, go to the properties for each file and determine where it is stored.

    Click on the windows button. Select Prepare and then select Properties. The path to the file will be shown.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,935

    Re: Extra personal.xlsb files

    Check:
    Excel Options
    ....Advanced
    ........At Startup, Open all files in
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    01-16-2014
    Location
    Boise, ID
    MS-Off Ver
    Excel 2007
    Posts
    2

    Smile Re: Extra personal.xlsb files

    Thank you! I found the second XLSTART folder with this guidance and was able to delete the extra files. Good as new!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Working with WorkBook Close event and Personal.xlsb files
    By coreytroy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2013, 12:40 AM
  2. Replies: 1
    Last Post: 08-08-2012, 09:23 AM
  3. Personal.xlsb locked
    By romandotcom in forum Excel General
    Replies: 0
    Last Post: 06-05-2012, 05:50 AM
  4. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  5. Excel 2007 : personal.xls and personal.xlsb in 2007
    By ali84pk in forum Excel General
    Replies: 0
    Last Post: 02-04-2011, 01:02 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1