Help Excel Issue

  • Thread starter Thread starter Deborah
  • Start date Start date
It means what it says, someone probably opened the file in Word and saved
when prompted,
that will make excel files pretty unusable
 
The Word folks need to fix that. People are losing their workbooks. I
brought it up with a Word MVP years ago. It's been doing that since Word97.
I think it's inexcusable.

Word warns that it'll be saved in Word format, but it keeps the xls
extension, and overwrites the xls file. I'm not kidding.
 
There are other ways for a file to end up unusable as well.
The best way to reduce loss of data is to take backups and
of course know where the backups are.
http://www.mvps.org/dmcritchie/excel/backup.htm

If you are running a business and don't have backups, you
automatically fail your audit. There is no valid excuse for
not having backups. Hardware can fail. Software can fail.
User handling and/or mistakes can destroy data.

Another way of losing data is to access removeable media
directly from Excel rather than from the harddrive. The worst
offenders was diskette drives and zip drives. But even though
CD and DVD drives are much more reliable you still should only
allow Excel to update files on your hard drive or on a network drive.
 
David,

All good points. But an xls file could get clobbered by Word, and backed up
in a rolling backup, and all the backups would be clobbered if it wasn't
discovered soon enough. Only archived backups would help then.
 
Offline backups are the only real backups, and at least one generation
should be offsite. Nice thing about CDs is that there in no recycling
to write over older backups so you essentially have all of them.
 
Back
Top