Excel question

[AdamSnow]

Hey everyone!

I just noticed something with Microsoft Excel XP... if I have 3 different excel files open, if I press the big X on the top of Excel... all of the workbooks close... now, in Word XP... if you have three different documents open and you press the large X... only the current document closes...

just wondering if anyone knows of a way to make excel only close the current excel workbook instead of every one that is open. I've lost a lot of work this way, and would like to prevent this from happening again.

Thanks for any help

 

[MrChad]

Click the little X below the big red X.

 

[AdamSnow]

Clearly... but that's not a solution to the problem in question...

 

[WW]

Originally posted by: AdamSnow

just wondering if anyone knows of a way to make excel only close the current excel workbook instead of every one that is open. I've lost a lot of work this way, and would like to prevent this from happening again.

Thanks for any help

didn't it come up with a dialog box asking if you want to save worksheet1? then save worksheet2, and so on? (only the ones with changes). Just cancel there if you make that mistake...

Word behaves the same when Tools> Options > View > Windows in Taskbar is unchecked.....then only one item is shown in the taskbar, and when you use the red X, it asks if you want to save each changed doc

There doesn't seem to be a way to make excel act like word...but you could simulate it by just opening a new instance of Excel for every new spreadsheet...try it

 

[Raincity]

I noticed this also when using Excel 2000 at work but when I use Excel 03 at home I dont have this problem.

 

[BFG10K]

Excel XP by default must be using MDI instead of SDI.

 

[AdamSnow]

Originally posted by: BFG10K
Excel XP by default must be using MDI instead of SDI.

Would you care to elaborate for me? Is there a way to change this or no ?




Thanks for the help everyone else... I appriciate it