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
Gord Dibben - 12 Sep 2006 21:50 GMT
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
>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
Zilbandy - 12 Sep 2006 23:24 GMT
>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!
Restore the file from your weekly or monthly backup copy you made.
dbahooker@hotmail.com - 12 Sep 2006 23:30 GMT
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
> 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
Zilbandy - 12 Sep 2006 23:47 GMT
>Excel isnt a database
>
[quoted text clipped - 5 lines]
>
>use a DATAbase for DATA entry jackass
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. :)

Signature
Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~