Solved excel spreadsheet shorted column by mistake

[messalion]

Hello there !!!
I am in a bad situation having made this mistake.
I have a client list with names/dates/purchases/phone numbers etc,my nephew was fooling around and he shorted the phone number list and now ALL the numbers are shorted with the names still intact.

I cant undo that cause its been saved.....i have a backup but without the phone numbers (witch i want VERY MUCH).

Is there anyway i can find a previous version or any other suggestion would be perfect

Thnx a lot and please excuse my bad english

 

[GokAy]

Can you post a screenshot please? http://www.sevenforums.com/tutorials/9733-screenshots-files-upload-post-seven-forums.html

Did you hide the column or just change formatting perhaps?

 

[messalion]

the column that is messed up is the green one......as you can see the numbers go from 0 to higher.Before the mistake all had the correct numbers inside the green column

 

[Ranger4]

I don't think there is much you can do about it. Once the spreadsheet has been changed & saved that is it. I know it's a bit late now but it explains how important having back ups is.

 

[messalion]

i "almost" convinced theres no backing up to my problem...but...is there any other way to........."recover" a previous version of the same document ? lets say a save before that has happend ? i remember i have pressed the save button 30 minutes-+ before that happend......
1 more detail.Thats a file from my computer.The file iam managing all the time is from my android tablet (i use it cause of mobility).is there a way to get something out of it ?

 

[Ranger4]

If you have a duplicate spreadsheet on your Android Tablet you should be able to copy it back to your computer. I do not copy files from my computer to my phone so I don't know if the websites listed below will work in your case, but it has to be worth trying.

Transfer files, apps & media from Android phone or tablet to microSD - How-To - PC Advisor

https://motorola-global-portal.cust.../~/droid---transfer-files-to/from-my-computer

How To Transfer Files From Android To PC

Do you use a cloud service such as OneDrive to store some files so you can get access to them remotely, if so then there could be a copy stored there.

 

[GokAy]

Maybe Shadow copies have backed up that one. Try "shadow explorer" software.

 

[messalion]

If you have a duplicate spreadsheet on your Android Tablet you should be able to copy it back to your computer.

how can i have a duplicate in my tablet ?

Do you use a cloud service such as OneDrive to store some files so you can get access to them remotely, if so then there could be a copy stored there.

No...unfortunately i copy my files using usb cable

Maybe Shadow copies have backed up that one. Try "shadow explorer" software.

i think your suggestion is my only option.....ill get back with more details after i used "shadow explorer"

Thnx

 

[messalion]

umm....a little help about "shadow explorer" ? Doesn't seems to find my tablet in its list of drives...it only sees my C drive

 

[GokAy]

Eh, sorry I haven't followed this thread after I went to sleep last night and there was no mention of the file being on a tablet

Shadow Explorer is only good for files on the PC.

Can you try something? Check the fields in that green column, and see if the values have changed? Maybe it was only the formatting? Check those that are 0 and also ones which have a number showing.

 

[messalion]

Eh, sorry I haven't followed this thread after I went to sleep last night and there was no mention of the file being on a tablet

Shadow Explorer is only good for files on the PC.

then shadow explorer cant help my situation

Can you try something? Check the fields in that green column, and see if the values have changed? Maybe it was only the formatting? Check those that are 0 and also ones which have a number showing.

I am sorry can u be more specific ?

 

[GokAy]

Select L2 and look at the value field (right above column headers - C, L, K etc)
Then down arrow to see what other fields look like, check the ones that are not 0 as well)
Hope it is clearer, not on a PC at the moment so can't post a screenshot.

 

[messalion]

Select L2 and look at the value field (right above column headers - C, L, K etc)
Then down arrow to see what other fields look like, check the ones that are not 0 as well)
Hope it is clearer, not on a PC at the moment so can't post a screenshot.

yah...it doesnt make it any clearer for me

 

[messalion]

ok ive done what you said.....and the fields change as the values on the green column too... e.g. L23 shows 12 on green column and 12 on the box above.....

 

[GokAy]

It was worth to check. I will post if I come up with any more ideas.

 

[messalion]

i can mark this thread as solved now cause.....iam gonna redo it 2 weeks of work

Thank you all for the kind answers and suggestions