Ladies & Gentlemen:

[HUSKER55]

I am having one of those days that is supposed to happen to somebody else. Today,....that lucky, (and handsome ), distinguished gentleman is me.

I have remembered why I hate computers. It is because they screw the living crap out of you at the most inconvenient time.

Today I was informed by excel that I had put an "if statement" in wrong. Instead of letting me correct it MS wiped out all of my formulas on every page in my book.

NEVER FORGET TO MAKE A COPY ON A SEPARATE DISC IN CASE OF SUCH EMERGENCIES.

I called MS and I was told they are working on it and an update would be available soon.

I think I got brushed off.

Don't forget your backups!

[Tom]

IF you like your formulas............... tough!
VE decide IF you keep them!

[HUSKER55]

just for that.....you are next

[Tom]

MS has been stalking me for years!

[HUSKER55]

well they missed an nailed me......I am less than a happy camper

[DeltaLover]

Originally Posted by HUSKER55

I nient time.

Instead of letting me correct it MS wiped out all of my formulas on every page in my book.

NEVER FORGET TO MAKE A COPY ON A SEPARATE DISC IN CASE OF SUCH EMERGENCIES.

What is preferable when it comes to things like formulas, coding and in general any document that might change due time is to keep it in a version control system as opposed of merely backing it up.

I strongly suggest the use of git: https://github.com/. It is a completely free if you decide to place your stuff on the open domain or if you prefer a private repo it is as cheap as $7/ month. There is a small learning curve associated with it, but if you are anywhere serious about your documents it certainly worths the effort..

[HUSKER55]

THANK YOU FOR THE INFO! REALLY APPRECIATE IT!

[FocusWiz]

Not that it is particularly straightforward for this particular situation, but this is one of the reasons why I use SugarSync to keep my spreadsheets copied among several computers. They also maintain several prior versions which are accessible if you need them sufficiently urgently enough to search through and read their website very carefully. Plus, if something happens to the entire drive (or computer), the information is in several additional places.

As I recall, this information (though their latest) is not quite up-to-date:

https://support.sugarsync.com/hc/en-...sions-of-files