If you're using xl2002+, make sure you turn on autorecovery:
tools|options|save tab.
If you're not using xl2002+, make sure you save often--well, even if you're
using xl2002+, that's a reasonable suggestion.
You may want to consider using Jan Karel Pieterse's addin called AutoSafe (note
spelling).
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.
And those suggestions won't help with your current problem. I think you'll be
making those changes again.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.