I have noticed that when I have multiple workbooks open with MS Excel and I close one, excel will attempt to close them all. This is extremely frustrating and has resulted in me losing work on many occasions.
Is there any way that I can stop Excel doing this so that it functions similar to MS Word?
I am using Excel 2003 SP3.
edit: i am aware that i can use the smaller 'x' button, however I was looking for a way to change current functionality of the main 'X'