Results 1 to 12 of 12
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Somehow my Excel is connected to 'Recovered PERSONAL.xls' rather than PERSONAL.xls

    How do I fix this?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Are you saying that you can't rename the file - after closing Excel? Or are you asking how to find the file so that you can rename it?
    Gre

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    How can I find PERSONAL.xls and get Excel to use IT, rather than the recovered version. That "recovered" business scares me.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Search your hard drive for XLSTART folders - there should be one in your Docs and Settings folder (or whatever your OS calls the equivalent) and one in the Office folder under Program Files.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    I found the XLSTART folder. It contains two files: 'PERSONAL.xls' and 'Recovered PERSONAL.xls'. NOW what do I do?

    (As I understand it, Excel finds PERSONAL.xls and uses it to determine what toolbars, etc. to open. How did Excel decide to use a diffferent file? How can I get it to go back to using the original one?)
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    With Excel closed, move the 'Recovered' version to another folder (don't delete it, just in case) then restart Excel.
    Note: Personal.xls does not set your toolbars, unless you have code in it to do so; it is merely the repository for your macros.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    I did as you suggest, with bad results. No macros showed up. I played around with the various PERSONALs, opening them, unhiding them, etc.

    Sometimes Excel would recognize the file and show me the macros, sometimes not.

    In the end, I renamed Recovered PERSONAL.xls to PERSONAL.xls. When I open Excel, it doesn't show me any macros.

    If I go to XLSTART and open PERSONAL.xls, the macros show up in workbooks that I create or open. But when I close out of Excel and restart it, no macros appear.

    Bottom line: All I've found that works is to leave the original, unrenamed, 'Recovered PERSONAL.xls' in my XLSTART folder. With this situation, if I open Excel and a new or old workbook, my macros appear (when I click Tools > Macro > Macros...). They identify themselves as being in 'Recovered PERSONAL'.

    PS - Where ARE the toolbars? I seem to remember a .XLB somewhere.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    There is a file called Excel11.xlb (for 2003; 10 for 2002 etc.) where the toolbars are stored - it's in:
    C:\documents and settings\username\application data\microsoft\excel
    under WinXP.

    I suspect that, if you are using 2003, if you look under Help-About Microsoft Excel and click the Disabled Items button, you would find Personal.xls listed?
    Regards,
    Rory

    Microsoft MVP - Excel

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sounds like you need to remove personal.xls and rename "recovered personal.xls" to personal.xls
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    I suspect that, if you are using 2003, if you look under Help-About Microsoft Excel and click the Disabled Items button, you would find Personal.xls listed?
    You are exactly right. Thanks!

    It makes sense... PERSONAL.xls causes trouble for Excel, so Excel creates a Recovered version and quarantines the original.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    So first remove personal.xls from that list, then do the renaming trickery.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts
    Yes, I have now done this. The key to the solution was the Disabled Items stuff, which I did not know about until coming here. After I figured that out, the rest was easy.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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