why do all excel files close when one closes?

  • Thread starter Thread starter FSt1
  • Start date Start date
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!
 
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
 
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
 
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
 
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
 
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.
 
That's it! Thanks very much (it's different in Word, as pressing the red x
leaves all other Word files still open)
 
Back
Top