Results 1 to 12 of 12
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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,322
    Thanks
    3
    Thanked 214 Times in 197 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, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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,322
    Thanks
    3
    Thanked 214 Times in 197 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, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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,322
    Thanks
    3
    Thanked 214 Times in 197 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, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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, USA
    Posts
    902
    Thanks
    153
    Thanked 11 Times in 10 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
  •