Wondering,

This is certainly good advice, and many don't back up their stuff, then weep when there's a
loss. In a case like this, though, if the sorting error isn't discovered quickly, the
backups get overlaid with the damaged one, unless backups are archived, or rotated for a
very long time.

I think Excel should do more to warn about a possible "Sort of Disaster," and recent
versions do, somewhat. But they're not reliable, and it's still possible for the
uninitiated to accidentally do the bad sort.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Wondering" wrote in message
...
A file as important as your customers should be backed up (copied) regularly. Some people
backup their important files daily at the end of the business day. Name the backup file
with the name of your customer file combined with the date of backup, e.g. "Customers Copy
9/29/2007". You might also want to protect your workbook so that changes can be made only
by authorized people who know what they are doing.

Dave


"_twin_mom_" wrote in message
...
We have been using Excel to hold our customer database. No one protected the
or froze the document cells. A few weeks ago, someone sorted the information
without highlighting the whole document, so now the names/addresses/phone
numbers don't match up.
Is there a way for us to see all the changes that have been made to the
document over a long period of time, and then go back to the fateful sorting
and undo it??
Otherwise, the document is worthless to us.
Help!