Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    I operate Vista Home Premium with office 7. I don't know what happened, when I close the worksheet showing cells, columns, etc., a second blank sheet appears with no cells that I have to close also. This second sheet never appeared previously.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    How are you closing the worksheet?

    There are two close buttons in the upper right corner of the Excel window:

    [attachment=82674:x.png]

    The top one closes the Excel application, the bottom one only closes the active workbook.

    Or is the name of the workbook in the title bar followed by :1 or :2 ? In that case, you have opened a second window on the same worksheet, and closing one window does not close the workbook.
    Attached Images Attached Images
    • File Type: png x.png (9.9 KB, 1 views)

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='763787' date='06-Mar-2009 00:36']How are you closing the worksheet?

    There are two close buttons in the upper right corner of the Excel window:

    [attachment=82674:x.png]

    The top one closes the Excel application, the bottom one only closes the active workbook.

    Or is the name of the workbook in the title bar followed by :1 or :2 ? In that case, you have opened a second window on the same worksheet, and closing one window does not close the workbook.[/quote]

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Did you intend to say anything besides quoting my reply?

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='763876' date='06-Mar-2009 15:29']Did you intend to say anything besides quoting my reply? [/quote]
    I guess this new system throws me. I thought I replied but could only find a preview button.

    Anyway. It works the same if I open a new Excel book or an existing one. There is only one X in the upper right corner. When I click on it the Excel sheet disappears and a blank sheet (no cells) is there. I then click on the X again to close.

    Ken

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Apparently Excel 2007 works differently in this respect than previous versions. Several MVPs have complained in vain.
    You can use the following alternatives:
    - Office button > Exit Excel
    - Press Alt+F4
    - Place the Exit button on the Quick Access Toolbar and use that.

  7. #7
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Cosby, Tennessee, USA
    Posts
    126
    Thanks
    2
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='763884' date='06-Mar-2009 15:57']Apparently Excel 2007 works differently in this respect than previous versions. Several MVPs have complained in vain.
    You can use the following alternatives:
    - Office button > Exit Excel
    - Press Alt+F4
    - Place the Exit button on the Quick Access Toolbar and use that.[/quote]
    Hans,
    I found the problem. In Excel options under Advanced I had the box "Show all Windows in the Taskbar" checked.
    Thanks!
    Ken

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='smokyken' post='764587' date='10-Mar-2009 14:58'][/quote]
    It's still a bug - Excel 2002 and 2003 don't work that way, whether "Show all Windows in the Taskbar" is ticked or not. And Word doesn't work that way either.

Posting Permissions

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