Is there any alternative way of closing single file instead terminating whole xls program?

Hi

Any ideas as to why the file becomes stuck is it because of something wrong with the file or just an infrequent glitch.

Chris

Hey Motivationalist;

The answer is a simultaneous Yes and No.

Yes, in that you can open up multiple instances of excel to provide a little more protection against a single instance crashing. So rather than just selecting the file and opening it, open excel from your start menu or quick icon link, and it will create a separate instance. The two separate instances can be move independently, having one on each monitor, tiled side by side, two separate ribbons, etc. If one crashes, I don't believe it will impact the other.

However, if one crashes, it's still going to crash every spreadsheet that's on that instance. So, not really protected that way.


This is also going by memory, and unfortunately, I'm not able to verify my statements at the moment. But it should function that way. Alternatively, under the File/windows button, and then Excel Options, the 4th tab is the save options, and you can increase the frequency of backups of your files to protect further against potential crashes/data loss.