Excel help needed

[Cancan]

Hi All,

I have been indexing using Excel 2007 edition.

I have seven columns across top A,B,C,D,E,F,G.  When I finish with the present work I highlight all work and organise it alphabetically.   

Now, for some reason 'Dopey here' has failed to highlight column G and have organised it all alphabetically as usual the other night. 
I have saved work as such.

Tonight I have just gone to do more indexing and have noticed that Column G isn't matching the information in the other columns!

Does anybody know if I can reset the work to the date I was working on the other night before I saved the index?  Or is there some other way to do this?

I'm really hoping there is a way, as with over 16,000 names I'm not wanting to start again, but have a feeling this is what is going to have to happen!

Fingers crossed XX!!!!

Cancan

[Erato]

Do you have Excel set up to create automatic backups?  These would be saved with an .XLK extension in the same directory with your spreadsheet.

[Cancan]

Hi,

Thank You!!

I believe it automatically saves every 10 minutes.
When I have finished and go to close,  it comes up  -   save index.xlsx'?

Not computer literate, so hope this makes sense

Cancan

[Cancan]

Hi Again,

I have just right clicked onto the file and gone into properties, there is a tab with 'previous restore', I'm thinking this is what you mean. 

There is a date a couple of days before MY last save of file, it does say I can restore to this date!

Just a little nervous of clicking 'Restore' 

Cancan

[Erato]

What I would do, just to be cautious, is this.  Exit Excel without saving your corrupted file.  Then make a copy of it in another location so you can get back to it if need be.  Then try the restore option.

[Cancan]

Hi,

Great News!!!

It has worked!!!  Have lost a few hundred names but at least that is a small amount to what I could have lost!! 

Lesson learned to double check that ALL columns are highlighted!!!

Learned something new, as did not know I could 'restore'

Thank You! Thank You! Thank You!!

Cancan 

[KGarrad]

Maybe, in future, don't highlight the cells!

Just click on any cell within the table, and do the Sort - it knows you want all rows and columns bounded by space-filled rows and columns!

[downside]

By right clicking an Excel file there is an item option Restore Previous Versions.

The number of versions available is dependent on where your use Windows Backup or not.  Additionally there are previous versions created by System Restore creating restore points but this is only available if you have System Protection turned on, which is normally switched on by default.

So although you have been lucky, you could have been luckier if you had taken regular backups.

I'm looking at one of my files that I do not use very frequently, but there are 19 versions available going back to 30/04/2012.  Because I do a weekly backup to a large disk, it means I can have that many versions available to restore if and when I want them.

I'm looking at another file and I see that the second version is available from a Restore Point rather than Windows Backup.  That is quite rare though.  It just demonstrates how important backups are.

[km1971]

Lesson learned to double check that ALL columns are highlighted!!!

If you click the top left box it highlights the whole sheet.

Better also to use Save As to create a new version each time and add the date in the title. Or add V1, V1.0, V2 etc after the name. For an important file you should also be keeping a copy 'off site'.

Ken