Close Workbook in Excel

[Brenda from Michigan]

User has Excel 2003 SP3. She likely previously had either 2000 or 2002.

If she has several workbooks open and/or minimized, then clicks the
uppermost right X on the active workbook, it closes Excel and all the other
workbooks, not just the active workbook. She is adament that Excel did not
used to work like this, that the uppermost X would close only the active
workbook. Can anyone confirm this change in behavior and/or let us know if
there is a way to change the behavior to close only the active workbook and
not the program? Thanks in advance.

 

[Kevin B]

On your users PC, open Excel and do the following:

1. Click TOOLS on the menu
2. Select OPTIONS from the drop-down menu
3. If necessary, click the VIEW tab of the dialog box
4. Click the WINDOWS IN TASKBAR check box.

Now each time a file is opened it opens in a separate session.

Hope this helps...

 

[Harald Staff]

Your friend is wrong. The uppermost X has always closed Excel. Think of it
as an application surrounding the open Excel files inside of it.

The way is to upgrade to Excel 2007, which doesn't mind which X you click,
it refuses to close.

HTH. Best wishes Harald

 

[Rick Rothstein]

To add to Harald posting...

IF the worksheets are NOT set to maximize, then each worksheet is in its own
"smaller" window (technical term is it is a Child Form for Excel's MDI Form)
and each worksheet has it own X to close itself. But if the worksheets are
set to maximize, then they fill the client area Excel provides for them and
the X your friend is looking at is Excel's X, not the worksheet's. You can
still close each worksheet separately with this setting, but the X is
smaller and located at the right side of the Menu Bar.