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

"janet inglis" wrote:

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 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
"janet inglis" <janet wrote in message
...
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!

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
wrote:

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!

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 wrote:

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!

--

Dave Peterson

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.

"Mike H" wrote:

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

"janet inglis" wrote:

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!

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

"John" wrote:

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
"janet inglis" <janet wrote in message
...
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!

You're welcome
John
"janet inglis" wrote in message
...
That's it! Thanks very much (it's different in Word, as pressing the red x
leaves all other Word files still open)

"John" wrote:

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
"janet inglis" <janet wrote in message
...
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!