why do all excel files close when one closes?

[FSt1]

hi
how are you closing the file(s)?
how are you opening them?

regards
FSt1

 

[janet inglis]

Whenever I close one excel file, all of the others close at the same time.
This is a huge nuisance, as sometimes I am working with several spreadsheets
at a time and have to retrieve and re-open them all. Please help!

 

[Mike H]

Hi,

Open the first workbook any way you want.

Start a second instance of excel.
either put a shortcut to excel.exe on your desktop and use that
or
windows startbutton|run
type:
excel
and hit enter

Then file|open the second workbook.

Mike

 

[John]

Hi Janet
If you have moore then one workbook open in one window, if you press the
"RED X"
on the top right, you will close everything, but if you press the other "X"
below the top one, second line, you will close only the workbook that you
see, only one at the time.
HTH
John

 

[Erik Haartmans]

Does CTRL-F4 work to prevent your nuisance? (=same as pressing
"worksheets X" instead of "excels X").

Met vriendelijke groet / Kind regards,
Erik Haartmans

On Wed, 4 Feb 2009 12:08:09 -0800, janet inglis <janet

 

[Dave Peterson]

xl2007????

If yes, then Ron de Bruin posted this:

Shift and clicking the close button will work in 2007

Unchecking "show all windows in taskbar" will give you the old behavior

 

[janet inglis]

Thank you for your help - I can see that this works and it's very helpful,
but it means a number of extra clicks. I think John's solution, i.e. to click
only the black x to close, and not the red one, is the simplest answer.

 

[janet inglis]

That's it! Thanks very much (it's different in Word, as pressing the red x
leaves all other Word files still open)

 

[John]

You're welcome
John

That's it! Thanks very much (it's different in Word, as pressing the red x
leaves all other Word files still open)