Go Back   Team-BHP > Around the Corner > Shifting gears > Gadgets, Computers & Software


Reply
 
Thread Tools Search this Thread
Old 7th April 2011, 13:16   #1
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 46,577
Thanked: 80,482 Times
Default Microsoft Excel : Tips, Issues, Etc.

Would greatly appreciate help on this, thanks!

So here's what happened:

- Created an excel sheet on my home laptop; I use Office 2007 and the excel sheet was saved in .xlsx format.

- Emailed it to myself for use at work. Spent another 3 hours on it yesterday, and closed it.

- Opened it once last afternoon and was able to access / view data.

- Needed it in the evening, but when opened, an error pop up read : Excel cannot open the file 'abc.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

- Because it all happened on the same day, I don't have a backup copy of the file either. It does contain some important data, and I'd highly appreciate any help on recovery.

- NOTE : What causes corruption? This had happened 2 months back, but luckily I just got a working copy of the corrupted file from my backup. As a temp fix, I've started saving all excel files in .xls format (and not .xlsx). My comp has a UPS, thus no power interruptions either.

Last edited by GTO : 7th April 2011 at 13:18.
GTO is offline   Reply With Quote
Old 7th April 2011, 13:20   #2
Senior - BHPian
 
androdev's Avatar
 
Join Date: May 2007
Location: bangalore
Posts: 1,513
Thanked: 1,454 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

While other will hopefully offer a better solution, you can always open it using notepad (or any plain text reader) and be able to see the raw text data. It will require rework to create the xls file again but the 'data' is available.
androdev is online now   Reply With Quote
Old 7th April 2011, 13:49   #3
Distinguished - BHPian
 
Stratos's Avatar
 
Join Date: Mar 2004
Location: Mumbai, IN
Posts: 2,591
Thanked: 1,208 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

You can try downloading this Microsoft Office Compatibility Patch
This will enable you to open the .xlsx file in previous generation offices. Might want to give it a try.

It will only work with Genuine Microsoft Office.
Stratos is offline   Reply With Quote
Old 7th April 2011, 13:52   #4
Senior - BHPian
 
HammerHead's Avatar
 
Join Date: Oct 2009
Location: Goan in Pune
Posts: 1,093
Thanked: 210 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

@ GTO, looks like know issue with MS Excel 2007.
Error message when you try to open a workbook that you receive in an e-mail message for review in Excel 2007: "Excel cannot open the file"

Suggestion: There are lot of applications available to recover Excel files, you may give it a try installing couple of them.
HammerHead is offline   Reply With Quote
Old 7th April 2011, 13:53   #5
Senior - BHPian
 
comfortablynumb's Avatar
 
Join Date: Jul 2007
Location: Pune
Posts: 1,245
Thanked: 824 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Rename the file to *.csv and then try opening it. It might work and is worth a shot.

Good luck!

Cheers,
Vikram
comfortablynumb is offline   Reply With Quote
Old 7th April 2011, 13:55   #6
BHPian
 
Join Date: Dec 2009
Location: Ghaziabad
Posts: 980
Thanked: 698 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

GTO, there is a product downloadable from internet that can convert xls / xlsx to csv. It is usually helpful in recovering corrupted datasets. Since, I am in office, I am not able to accessthese sites for download. Try searching for "xls2csv" and download a trial version of this, and see if it works for you. I have tried this successfully in the past.

By the way, have you considered the Open Document Formats? They are supported by MS Office as well.
roy_libran is offline   Reply With Quote
Old 7th April 2011, 14:07   #7
GTO
Team-BHP Support
 
GTO's Avatar
 
Join Date: Feb 2004
Location: Bombay
Posts: 46,577
Thanked: 80,482 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by androdev View Post
While other will hopefully offer a better solution, you can always open it using notepad (or any plain text reader) and be able to see the raw text data. It will require rework to create the xls file again but the 'data' is available.
The data that shows up is incomprehensible (only weird characters & symbols)

Quote:
Originally Posted by Stratos View Post
You can try downloading this Microsoft Office Compatibility Patch
This will enable you to open the .xlsx file in previous generation offices. Might want to give it a try.

It will only work with Genuine Microsoft Office.
Stratos, that tool - though helpful - is to open the xlsx files on older versions of MS Office. Not applicable to my problem.

Tried renaming the file extentions; no luck.

Quote:
Originally Posted by comfortablynumb View Post
Rename the file to *.csv and then try opening it. It might work and is worth a shot.
Same problem as notepad. Opens up, but is incomprehensible.

Quote:
Originally Posted by roy_libran View Post
Try searching for "xls2csv" and download a trial version of this, and see if it works for you.
Tried. Shows empty CSV rows & columns.
GTO is offline   Reply With Quote
Old 7th April 2011, 14:21   #8
Team-BHP Support
 
bblost's Avatar
 
Join Date: Jul 2007
Location: Hyderabad
Posts: 9,556
Thanked: 6,313 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

GTO: 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.

Select View It. Hopefully the google application is able to open the file and show it to you.
bblost is offline   Reply With Quote
Old 7th April 2011, 14:22   #9
Senior - BHPian
 
pjbiju's Avatar
 
Join Date: Apr 2006
Location: Karamattom, Aluva, Kotagiri, Yercaud, Hospet, Indore, Nashik, Pune (now)
Posts: 1,167
Thanked: 433 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

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. Copy those files and give them the extension of .xlsx. Open them to see if anything matches with your original excel file. Also check if Autorecover is enabled (under excel options) and if so, check in the autorecover folder for a copy of your file.

Last edited by pjbiju : 7th April 2011 at 14:35.
pjbiju is offline   Reply With Quote
Old 7th April 2011, 14:41   #10
Senior - BHPian
 
NetfreakBombay's Avatar
 
Join Date: Jan 2008
Location: Bombay
Posts: 1,375
Thanked: 315 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

GTO,

.xlsx (and docx / pptx) are zip files.

Please try this:

1. Create a copy of file and rename this copy to .zip
2. See if you can unzip it. If you can't, this is the root cause
3. If you can't unzip it, try some zip recovery software : Fix zip file with DiskInternals ZIP Repair

If this works and can recover partial data, we can work on getting it back into excel.
NetfreakBombay is offline   Reply With Quote
Old 7th April 2011, 14:49   #11
BHPian
 
dre@ms's Avatar
 
Join Date: Oct 2006
Location: Singara Chennai
Posts: 480
Thanked: 96 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

@NetfreakBombay
Are you sure pal. Those extensions you have mentioned is for Office 2007 and above.

I tried the same and when opening or unzipping, shows corrupt or damaged.

@GTO
Are you using Office 2007/2010 at your office too?

Its worth a shot trying to open with Open Office. Most issues with my excel/word have been solved using the same.
dre@ms is offline   Reply With Quote
Old 7th April 2011, 15:11   #12
Senior - BHPian
 
NetfreakBombay's Avatar
 
Join Date: Jan 2008
Location: Bombay
Posts: 1,375
Thanked: 315 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

^^

yes, 2007 and 2010 use zip for storing files. Data is stored as XML and compressed to zip for reducing size.

Regarding:

Quote:
I tried the same and when opening or unzipping, shows corrupt or damaged.
What are first two bytes of file? Is it "PK" ?
NetfreakBombay is offline   Reply With Quote
Old 7th April 2011, 15:42   #13
BHPian
 
alexpaul's Avatar
 
Join Date: Apr 2010
Location: London-Kochi
Posts: 71
Thanked: 15 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by GTO View Post
Would greatly appreciate help on this, thanks!

So here's what happened:

- Created an excel sheet on my home laptop; I use Office 2007 and the excel sheet was saved in .xlsx format.

- Emailed it to myself for use at work. Spent another 3 hours on it yesterday, and closed it.

- Opened it once last afternoon and was able to access / view data.

- Needed it in the evening, but when opened, an error pop up read : Excel cannot open the file 'abc.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

- Because it all happened on the same day, I don't have a backup copy of the file either. It does contain some important data, and I'd highly appreciate any help on recovery.

- NOTE : What causes corruption? This had happened 2 months back, but luckily I just got a working copy of the corrupted file from my backup. As a temp fix, I've started saving all excel files in .xls format (and not .xlsx). My comp has a UPS, thus no power interruptions either.

GTO , access the excel options (will see this option below when you click on office icon on an open excel document), navigate to save option and verify whether the below mentioned field has same settings in both your office and home laptop

"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.
alexpaul is offline   Reply With Quote
Old 7th April 2011, 15:58   #14
BHPian
 
Join Date: Dec 2009
Location: Ghaziabad
Posts: 980
Thanked: 698 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by GTO View Post
Tried. Shows empty CSV rows & columns.
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.
roy_libran is offline   Reply With Quote
Old 7th April 2011, 16:14   #15
BHPian
 
sanagg1's Avatar
 
Join Date: Apr 2009
Location: HIMALYAS
Posts: 274
Thanked: 2 Times
Default Re: IMP Excel sheet got corrupted. Any possibility of recovering data?

Quote:
Originally Posted by NetfreakBombay View Post
yes, 2007 and 2010 use zip for storing files. Data is stored as XML and compressed to zip for reducing size.
This is a nice information, I think for many of us also.
Thanks for sharing

Cheers
sanagg1 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Office; Tips & Shortcuts prateek99 Shifting gears 10 9th August 2011 15:24
Tata 407 vs Force Excel 4 LCV. Which one? itsmevivek Commercial Vehicles 12 3rd April 2007 09:43
Tax Calculator (excel) required protege Shifting gears 4 30th July 2006 22:40
Fiat Panda to be launched as Tata Excel Minardi The Indian Car Scene 28 5th June 2006 12:15


All times are GMT +5.5. The time now is 07:29.

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