Undoing a change that has been saved

P

Pedro

I Have a database with close to 3,000 addresses on it. I put it in zip code
oreder then saved it and closed it when I reopened it and realized I had only
arranged the ZIP code and not the addresses that go with them. Is there a way
to go back and find an old one. Or to undo a change of the nature?
Please help!
Thanks
 
G

Gord Dibben

You cannot undo a change once the workbook has been saved.

Do you have a backup copy somewhere?

Did you ever send the file to a friend or co-worker?

Are you set up under Save options to "always create a backup"?

If so, you will have a backup of the save before the latest one.

Look for *.XLK files.


Gord Dibben MS Excel MVP
 
Z

Zilbandy

I Have a database with close to 3,000 addresses on it. I put it in zip code
oreder then saved it and closed it when I reopened it and realized I had only
arranged the ZIP code and not the addresses that go with them. Is there a way
to go back and find an old one. Or to undo a change of the nature?
Please help!
Click to expand...

Restore the file from your weekly or monthly backup copy you made.
 
D

dbahooker

Excel isnt a database

stop trying to use it as one

it' doesnt have data entry input masks; audit trails.

excel is for babies

use a DATAbase for DATA entry jackass

-Aaron
 
Z

Zilbandy

Excel isnt a database

stop trying to use it as one

it' doesnt have data entry input masks; audit trails.

excel is for babies

use a DATAbase for DATA entry jackass
Click to expand...

Congratulations! Since this is the second time in a few days you've
used these words to critisize someone, you just make my killfile. See
ya, you turd. :)
 
Top