How to recover overwritten spreadsheet...

[Jim@HiTek]

This has happened to me several times:

I'll open a spreadsheet (SS) with multiple pages; add an entry; open another related SS to check on something, perhaps make a change to the 2nd SS; go back to the 1st SS and for some reason the 1st SS is BLANK, but carries the correct name of the first opened SS, and all my data is missing! (Not every time, but 4-5 times a year).

Usually, when this happens, I just don't click 'save' when I exit the program, but this last time I inadvertently clicked on 'save' and now my large SS is blank.

Is there a way to recover the overwritten data (4 pages worth)?

How do I set up eXcel to avoid this bug? I've tried setting the 'Save As' option to 'Always create backup' but is there a way to get that option to stay checked all the time?

What I'd like is a time stamped stack of 5 to 10 backup copies of all my SS's at all times...is there a way to do that?

(I don't have a current enough full backup of the HDD to restore an older copy).
(I've tried various online 'restore eXcel spreadsheet' programs w/o success).

Thanks!

[Bryan Hessey]

This has happened to me several times:

I'll open a spreadsheet (SS) with multiple pages; add an entry; open another related SS to check on something, perhaps make a change to the 2nd SS; go back to the 1st SS and for some reason the 1st SS is BLANK, but carries the correct name of the first opened SS, and all my data is missing! (Not every time, but 4-5 times a year).

Usually, when this happens, I just don't click 'save' when I exit the program, but this last time I inadvertently clicked on 'save' and now my large SS is blank.

Is there a way to recover the overwritten data (4 pages worth)?

How do I set up eXcel to avoid this bug? I've tried setting the 'Save As' option to 'Always create backup' but is there a way to get that option to stay checked all the time?

What I'd like is a time stamped stack of 5 to 10 backup copies of all my SS's at all times...is there a way to do that?

(I don't have a current enough full backup of the HDD to restore an older copy).
(I've tried various online 'restore eXcel spreadsheet' programs w/o success).

Thanks!

Hi,

not a problem that I've ever encountered.

As you know 'backups' are useful, and here one would have saved the day (or at least, some of your data).

Do you have VB code running? - if so what does it do, and what does it do if the focus is not correctly set? (ie, if you switch books whilst the code is running?)

When you say that 'all of your data is missing', are the sheets still there but blank? or have the sheets been removed?

What code do you have that clears a sheet? (a working sheet after some data shuffle?)

any other clues?

---