+ Reply to Thread
Results 1 to 6 of 6

Multiple PERSONAL.xlsb files - which to keep - how to delete

  1. #1
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Question Multiple PERSONAL.xlsb files - which to keep - how to delete

    I don't know how this happened - but today, I was prompted with the following list of MULTIPLE personal.xlsb files
    asked -- which one(s) to keep?

    I opened each, checked out the MODULES and find that the very bottom (original PERSONAL.xlsb) file is a good one (has my most recent Modules in it)
    Also, the very top one listed: PERSONAL (version1) - seems to mirror the original one -- with the same quantity of modules in my module list.

    The other 2 listed in the middle did not hold all of my modules and should be deleted - but when I right click on them to delete; it's not an option.
    See attached image -- to see what I'm seeing and to see what options are available when I right click (shown in red bordered window at right)
    Is there a different place I need to go to remove those extra copies?

    Hoping someone knows how to clean this up before something bad happens to my valuable Personal file!
    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Multiple PERSONAL.xlsb files - which to keep - how to delete

    Check you xlstart up folder to see if somehow that's where multiple .xlsb files are located.

    https://bettersolutions.com/excel/ma...sonal-xlsb.htm
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Question Re: Multiple PERSONAL.xlsb files - which to keep - how to delete

    Thx for tip on where to locate --- here's what I'm seeing in the EXCEL file (just before drilling 1 step deeper into the XLSTART) --SEE ATTCHD
    and also what's sitting in the XLSTART...
    I'm wondering if it is OK/SAFE to delete all the xlsb line items in both folders (that are not the main/original PERSONAL.xlsb)?

    SPECIFICALLY:
    Delete all for items in the EXCEL folder (circled in red)
    Then go to the XLSTART folder and delete the "auto recovered" line item but leave the "PERSONAL" line at bottom in place.

    ?
    Attached Images Attached Images

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Multiple PERSONAL.xlsb files - which to keep - how to delete

    Quote Originally Posted by CHRISOK View Post
    I'm wondering if it is OK/SAFE to delete all the xlsb line items in both folders (that are not the main/original PERSONAL.xlsb)?
    I see no reason why not. If this was my computer that what I would do. As you say, you have one main personal.xlsb and nothing else. If you have concern, you can also removed the extra files to some safe backup spot and after all is working fine, delete the unnecessary.

  5. #5
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Re: Multiple PERSONAL.xlsb files - which to keep - how to delete

    All is good! - I've cut all the extras out of both places and saved them into a diff folder - all seems to be working well -- will keep on hand a few days to confirm.
    Thank you

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Multiple PERSONAL.xlsb files - which to keep - how to delete

    Awesome and you are very welcome. Glad it has worked out so far.

+ 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. Personal.XLSB not loading with other files
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2016, 09:52 AM
  2. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  3. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  4. Extra personal.xlsb files
    By SRHEXCEL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2014, 10:38 AM
  5. [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
  6. DELETE the Personal.XLSB macro I created - can't get rid of it!
    By Cut2please in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2013, 07:51 PM
  7. Replies: 1
    Last Post: 08-08-2012, 09:23 AM

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