Is there a way to trace changes made to a spreadsheet?
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!
|