+ Reply to Thread
Results 1 to 4 of 4

Personal.xls and personal.xlb keep opening and reopening

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Personal.xls and personal.xlb keep opening and reopening

    Hello

    the two file seem to open each time I open an Excel file so I end up with two file opens all the time and few more "Read Only"..which is quite annoying ..any suggestions please ?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,719

    Re: Personal.xls and personal.xlb keep opening and reopening

    For Excel 2010 on Vista/7 (I suppose 8 is the same), PERSONAL.xlb is found in

    C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

    and opens automatically whenever you open Excel. However, it should be hidden so you don't notice it. If you open Excel and it is not hidden, you can simply go to View, Hide to hide it. When you close Excel answer Yes when it asks you if you want to save your changes.

    PERSONAL.xls is a leftover from earlier versions of Excel and is found in the same folder. If you don't want or need it, you can delete it.

    I don't know what is going on with your "few more 'Read Only'" files. If you have other files in that same folder, they will be opened automatically also.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Personal.xls and personal.xlb keep opening and reopening

    Handy Trick!! it works ..Thank you..

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,719

    Re: Personal.xls and personal.xlb keep opening and reopening

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

    Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.

    If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.

+ 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. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  2. Opening Excel only Personal Opens
    By sbworcs in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 10:22 AM
  3. Calling Personal.xls functions without needing a 'personal.xls!' prefix
    By Skywalker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2010, 02:43 AM
  4. PERSONAL Workbook is not opening
    By JuanM in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 11:50 AM
  5. [SOLVED] How do I keep the personal.xls from opening?
    By dbritt in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 03:10 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