Results 1 to 7 of 7

Thread: Open Excel

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Problem: When I open excel, the program actually opens two workbooks, "Personal.xlsb", which is the visiblke one, and "Personal (Autosaved).xlsb". How can I get back to normal, i. e., opens to "Book1"?
    Thanks in advance.

  2. #2
    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
    Hide Personal.xlsb, then close Excel and answer yes to saving changes. Now locate the Personal (Autosaved).xlsb workbook in your XLSTART folder and delete it.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Rory. Unfortunately, after I did as you instructed, when I open Excel, I get the gray blank page. When I go to View, Hide, I get a dropdown menu asking which of either PERSONAL.XLSB or Personal (Autosaved).xlsb I would like to view. Any thoughts? I ran a search just to make sure and did not see any Personal (Autosaved).xlsb file.

  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
    Did you delete the autosaved version?
    Open a blank workbook, save it as a template called book.xltx in your XLSTART folder.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    OK, I seem to have remedied my problem, but now when I close Book1, Excel does not completely close, but I get the gray screen again that I have to close as well! Any ideas?


  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
    If you have any startup files (such as the personal macro workbook) then that is the way Excel behaves in 2007 and 2010, unfortunately. You have to hold down shift and then click the application X
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Rory.

Posting Permissions

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