I spent 5 hrs. on a spreadsheet and after I thought I saved it I can't seem to find it. I've tried a search but to no avail. At the time I saved it I had an older spread sheet opened and when I tried to close that one I recieved a "Do you want to save changes" message. Since I made no changes to that document I clicked NO and I think they both closed. What did I do wrong and where is the new document?
2007-08-22 17:31:54 · 3 answers · asked by osogimpy 1 in Computers & Internet ➔ Software
That's one of the real buggars with Excel, even in the newest version. If you have more than one spreadsheet open and say only one of them is changed, when you close Excel it'll prompt you to save the changed worksheet even if it's not the one you're currently looking at. If you're not careful, you'll loose your changes as I suspect you have done.
I wish that when multiple Excel files were opened, they'd open in seperate windows to avoid this mistake.
2007-08-22 17:43:58 · answer #1 · answered by BigRez 6 · 0⤊ 0⤋
That's why you want to click the close window button (second x button down), not the close excel button (big X button in title bar).
Even when you have two worksheets open and the current one has had no changes and you choose close excel, the current workbook will close and the message asking about saving changes to [filename] will appear in front of the unsaved changed worksheet.
Sorry, if you said no, then your 5 hours of work is not saved.
And the latest version of Excel, 2007, has just come out, so you are not that far behind at all. I prefer the 2003 version.
Just a note, Excel and Word work differently in this regard even though they are both from Microsoft - you'd think they could get together on this.
2007-08-22 18:48:36 · answer #2 · answered by vbmica 7 · 0⤊ 0⤋
2003? Get with the times man! That was 4 years ago!
2007-08-22 17:39:40 · answer #3 · answered by dirtmerchant_12b 3 · 0⤊ 3⤋