Team-BHP > Shifting gears > Gadgets, Computers & Software


Reply
  Search this Thread
15,433 views
Old 7th April 2011, 16:42   #16
Distinguished - BHPian
 
dhanushs's Avatar
 
Join Date: Oct 2009
Location: Chennai
Posts: 4,267
Thanked: 9,789 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by roy_libran View Post
Ok, I think I know the problem. I think the data is in the Buffer File, that is automatically created in the same folder (look in hidden files). Try locating that file, and rename that file, and follow the conversion procedure to see if it works.
But wouldn't excel show a list of buffer files in the folder, upon opening?.

Though worth a try, because, I think, the purpose of a buffer file is to save data 'as and when created' so that even in the case of, say, power failure, data is not lost.
dhanushs is offline  
Old 7th April 2011, 17:12   #17
BHPian
 
Join Date: Apr 2010
Location: Cochin
Posts: 203
Thanked: 197 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

If the amount of data is less then try the zip route.

Rename the file to ZIP. extract it. There will be a folder named worksheets.

Inside that you will have files with name of the sheet (Sheet1.xml, Sheet 2.xml etc)

Open the XML file in notepad.

The data will be in the XML modes

- <sheetData>
- <row r="3" spans="1:6">
- <c r="A3">
<v>DATA GOES HERE</v>

</c>


- <c r="C3">
<v>DATA GOES HERE</v>

</c>


- <c r="F3">
<v>DATA GOES HERE</v>

</c>


</row>


</sheetData>



You can manually save the data from these xml files.

Yes...Its dire boring and time consuming!
Sedate is offline  
Old 7th April 2011, 17:44   #18
Senior - BHPian
 
ph03n!x's Avatar
 
Join Date: Jun 2008
Location: Coimbatore
Posts: 2,561
Thanked: 5,952 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Rush, you said you mailed it to your work email - can you open it from your email sent / inbox? Or have you made a bunch of changes in the 3 hours you worked on it?

And if you are on Win 7, see if you have a Previous Version - right click on the corrupted file in its original location > properties > previous version
Microsoft Excel : Tips, Issues, Etc.-prev-ver.jpg
ph03n!x is offline  
Old 7th April 2011, 17:53   #19
Distinguished - BHPian
 
mayankk's Avatar
 
Join Date: Apr 2010
Location: New Delhi
Posts: 5,139
Thanked: 8,119 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

umm.Google docs may open the file.
Not too sure though.
i HAVE used it to open xlsx files, but it loses all the formatting etc, just base data is shown.
Pain to get down to an xls(but i think that might be the least of your problems.data might be more important for you).

Edit: oh wait, bblost already gave this info....
mayankk is offline  
Old 7th April 2011, 18:24   #20
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 70,335
Thanked: 298,732 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Firstly, thank you for the effort & help guys.

Quote:
Originally Posted by bblost View Post
Not quite sure how this will work. But email it to a gmail account.

Then when you open the email in gmail it will ask if you wish to view it or download it.
Tried. Message reads "Sorry, we are unable to generate a view of the document at this time. Alternatively, you can view the plain HTML (automatically redirecting)." HTML view shows a bunch of weird characters.

Quote:
Originally Posted by pjbiju View Post
Check if you have any files without any extension residing in the same folder that had the xlsx file. The name could be something like "D647FD10" etc.
No file.

Quote:
Also check if Autorecover is enabled (under excel options) and if so, check in the autorecover folder for a copy of your file.
Autorecover is indeed enabled. But the only thing in that folder is a sub-folder titled "XLSTART".

Quote:
Originally Posted by NetfreakBombay View Post
Create a copy of file and rename this copy to .zip
Quote:
Originally Posted by Sedate View Post
If the amount of data is less then try the zip route.

Rename the file to ZIP. extract it. There will be a folder named worksheets.
Doesn't extract. Had tried this morning. IIRC, error said something on the lines of invalid archive.

Quote:
Originally Posted by dre@ms View Post
@GTO Are you using Office 2007/2010 at your office too?
Yup.

Quote:
Its worth a shot trying to open with Open Office.
Downloading Open Office as I type.

Quote:
Originally Posted by alexpaul View Post
"Save files in this format" < field box >

Probably your office laptop must have the settings to save the document in .xls format instead of .xlsx format and thats where the existing file is getting corrupted.
Both had xlsx, but I just changed them to xls. Never had a corrupt xls till date.

Quote:
Originally Posted by roy_libran View Post
Ok, I think I know the problem. I think the data is in the Buffer File, that is automatically created in the same folder (look in hidden files). Try locating that file, and rename that file, and follow the conversion procedure to see if it works.
No other file at all, Roy.

Quote:
Originally Posted by ph03n!x View Post
Rush, you said you mailed it to your work email - can you open it from your email sent / inbox? Or have you made a bunch of changes in the 3 hours you worked on it?
The main work was those three hours of changes

Quote:
And if you are on Win 7
On XP
GTO is offline  
Old 7th April 2011, 18:28   #21
Senior - BHPian
 
theexperthand's Avatar
 
Join Date: Oct 2008
Location: Bangalore
Posts: 1,633
Thanked: 2,448 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

GTO, can you make a copy of the file and rename it to zip, and try using Disk internals zip repair utility to repair the zip file? May be you will be able to extract the zip file after the repair.

link: Fix zip file with DiskInternals ZIP Repair
theexperthand is offline  
Old 7th April 2011, 18:45   #22
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 70,335
Thanked: 298,732 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

^ Didn't work. The list of repaired zip files draws a blank.
GTO is offline  
Old 7th April 2011, 19:03   #23
BHPian
 
sadnabrina's Avatar
 
Join Date: Oct 2005
Location: Kolkata
Posts: 389
Thanked: 535 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

I have seen the exactly same error while trying to open files which are initially saved as ".XLS" and later renamed (through windows explorer) to .XLSX.

Did you try renaming the file to ".XLS" and open it?
sadnabrina is offline  
Old 7th April 2011, 19:45   #24
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 70,335
Thanked: 298,732 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by sadnabrina View Post
I have seen the exactly same error while trying to open files which are initially saved as ".XLS" and later renamed (through windows explorer) to .XLSX.

Did you try renaming the file to ".XLS" and open it?
Did, but no luck. I've responded to your PM and sent you the file as well

Thanks
GTO is offline  
Old 7th April 2011, 22:29   #25
Senior - BHPian
 
Join Date: Dec 2009
Location: DNCR
Posts: 1,634
Thanked: 3,403 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Ok GTO. Here's another option. Try downloading a Data Recovery Utility and point it to scan the drive on which the file was resident. It might detect a previous image of that file, that you can then ask that utility to save separately. Also, look for Buffer Files (similar to one user has pointed out on page 1) that were created around the time your file got deleted, using the same utility. You might be able to pick up the buffer image, if not an image of the original file.

I have tried these utilities in the past to recover accidentally deleted data from my disks, and I have been mostly successful.

I am assuming that the data is terribly important to you, and hence all this conversation is happening; so this round-about approach might be worth a try.
roy_libran is offline  
Old 8th April 2011, 08:56   #26
BHPian
 
luky_13's Avatar
 
Join Date: Nov 2008
Location: Bangalore
Posts: 580
Thanked: 156 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

I was in a similar fix a year back, some financial data in an Excel, xlsx went bad and the file was 'unrecognizable'. Almost went into panic mode before hitting on this site Excel Recovery Software recovers & repair corrupted Excel File . It actually worked and I was able to recovery all my data in the nick of time.

You could give it a try.
luky_13 is offline  
Old 8th April 2011, 11:12   #27
BHPian
 
dre@ms's Avatar
 
Join Date: Oct 2006
Location: MADRAS
Posts: 638
Thanked: 206 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Any update GTO? Tasted success?
dre@ms is offline  
Old 11th April 2011, 09:11   #28
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 70,335
Thanked: 298,732 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by roy_libran View Post
Try downloading a Data Recovery Utility and point it to scan the drive on which the file was resident.
Thanks Roy, I will try this.

Quote:
Originally Posted by luky_13 View Post
http://www.stellarinfo.com/excel-recovery.htm
On my way to download.

Quote:
Originally Posted by dre@ms View Post
Any update GTO? Tasted success?
Not yet, unfortunately. I'm going to give this till tomorrow. If it doesn't work, will start recompiling the data from my grey cells . It's now damage limitation mode.
GTO is offline  
Old 11th April 2011, 09:25   #29
Senior - BHPian
 
Join Date: Nov 2009
Location: India
Posts: 1,900
Thanked: 2,241 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by roy_libran View Post
Ok GTO. Here's another option. Try downloading a Data Recovery Utility and point it to scan the drive on which the file was resident. It might detect a previous image of that file, that you can then ask that utility to save separately. Also, look for Buffer Files (similar to one user has pointed out on page 1) that were created around the time your file got deleted, using the same utility. You might be able to pick up the buffer image, if not an image of the original file.

I have tried these utilities in the past to recover accidentally deleted data from my disks, and I have been mostly successful.
Highly unlikely to work, cos the older version was overwritten by the new version, after it was worked upon for 3 hours.

Remember, data recovery software work only when those sectors which are to be recovered are not overwritten by data. If we run the data recovery utility now, all we would get is the corrupt file. My take on this.

@Rush: If Autorecover option is enabled, MS Excel should have saved a backup every 10 minutes, by default. Check for any stray xl sheets in the "Application Data\Microsoft\Excel" path in the C drive. This path differs from OS to OS, check what it is for XP and look for any files there.
DRIV3R is online now  
Old 11th April 2011, 18:45   #30
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 70,335
Thanked: 298,732 Times
Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

DRIV3R, Thanks but the application data folder has no such file.
GTO is offline  
Reply

Most Viewed
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Copyright ©2000 - 2024, Team-BHP.com
Proudly powered by E2E Networks