MajorGeeks Support Forums

Go Back   MajorGeeks Support Forums > ----------= PC, Desktop and Laptop Support =---------- > Software
Register FAQ Members List Calendar Casino Mark Forums Read

Software Software such as operating systems like Windows XP, Windows Vista, Windows 7 etc., or specific programs.


Reply
 
Thread Tools Display Modes
  #1  
Old 03-03-11, 01:41
angelia angelia is offline
Private E-2
 
Join Date: May 2010
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
Default xls 2003-file not in a recognizable format

Hi there,
I have received an xls file created with Excel 2003, that suddenly gives me the error that This file is not in a recognizable format. It does open with EXCEL 2003 but in gibberish:
4H γŒ:d π:D ϊ gΡ2ξ]ΥWlUc λvΤ l
RTU?žf tˆήΐ΄1γ"ΔϋOUϋ˜Ή2ΩULΥΔε[ΚC―Τn΅ϋ IΤΆUι aη Jέ4θλΒŠή}Δs θώκς οšu& k τΔύ*ΐ.3ξΓυ ρNΓ4

Using Word or Notepad, it is opening in gibberish again.
I am using only Excel 2003 (no other version) and Windows XP with XP3.
I have tried to save the file in SILK format, html but still no results.

Is there any possibility I can recover the initial information contained in the file? or at least part of it.

Thank you very much in advance
Reply With Quote
Sponsored links
  #2  
Old 03-03-11, 04:54
GCWesq GCWesq is offline
Major Geek
 
Join Date: Jun 2008
Location: Lilydale, Victoria, Australia
Posts: 1,041
Thanks: 95
Thanked 108 Times in 98 Posts
Default Re: xls 2003-file not in a recognizable format

Are you certain it was created in Excel 2003 and not a later version, and that it was saved as an xls 2003 file?
Can you try opening it on another computer (maybe send it to someone else if you don't have another computer you can try)?
Reply With Quote
  #3  
Old 03-03-11, 05:28
angelia angelia is offline
Private E-2
 
Join Date: May 2010
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
Default Re: xls 2003-file not in a recognizable format

Quote:
Originally Posted by GCWesq View Post
Are you certain it was created in Excel 2003 and not a later version, and that it was saved as an xls 2003 file?
Can you try opening it on another computer (maybe send it to someone else if you don't have another computer you can try)?
Thank you very much for your reply.
Yes, I am certain that it was created with Excel 2003 and saved in Excel 2003. I do not use another versions of Excel.
I have tried on another computers, all with Office 2003 and I am getting the same results, opening the file in gibberish. The Microsoft Office Application Recovery does not fix the problem.

Thank you
Reply With Quote
  #4  
Old 03-03-11, 05:35
GCWesq GCWesq is offline
Major Geek
 
Join Date: Jun 2008
Location: Lilydale, Victoria, Australia
Posts: 1,041
Thanks: 95
Thanked 108 Times in 98 Posts
Default Re: xls 2003-file not in a recognizable format

Your last post makes it sound like you created the file yourself, but in your first post you said you received the file.
Assuming you created it yourself, do you have a backup of it, and if so, does that open properly?
Have you tried creating another workbook and see how that works, to see if your Excel is corrupt (you could use the repair tool and see if that works, if so). The corrupt file (which it seems to be) may have been corrupted by your Excel, if that is damaged.
Also, do you happen to have the Office 2007 or 2010 converter on your computer.
Is Word working OK?
Reply With Quote
  #5  
Old 03-03-11, 06:12
angelia angelia is offline
Private E-2
 
Join Date: May 2010
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
Default Re: xls 2003-file not in a recognizable format

Quote:
Originally Posted by GCWesq View Post
Your last post makes it sound like you created the file yourself, but in your first post you said you received the file.
Assuming you created it yourself, do you have a backup of it, and if so, does that open properly?
Have you tried creating another workbook and see how that works, to see if your Excel is corrupt (you could use the repair tool and see if that works, if so). The corrupt file (which it seems to be) may have been corrupted by your Excel, if that is damaged.
Also, do you happen to have the Office 2007 or 2010 converter on your computer.
Is Word working OK?
Hi there again and thank you for your reply. Yes, I did receive the file, it was not created by myself. I have asked the person who sent it to me how the file was created. I received it damaged and unfortunately there is no backup of the file.
Excel is working OK, I am using it on regular base, and no other problems were encountered. The "Open and repair" option did not help me to recover the data from the file. I am getting only gibberish.

Yes, I do have the Office 2007 converter but not on the computer where the file was damaged. Yes, Word is working OK.
Reply With Quote
Sponsored links
  #6  
Old 03-03-11, 09:40
sach2's Avatar
sach2 sach2 is offline
Major Geek Extraordinaire
 
Join Date: Nov 2006
Posts: 7,584
Thanks: 604
Thanked 1,801 Times in 1,718 Posts
Default Re: xls 2003-file not in a recognizable format

Maybe try an online converter service to see if it can recognize the document. If you get an error from a couple of them then you know something is seriously wrong with the file.
Reply With Quote
  #7  
Old 03-03-11, 12:14
MrBloody369 MrBloody369 is offline
Private E-2
 
Join Date: Jun 2009
Posts: 22
Thanks: 4
Thanked 0 Times in 0 Posts
Default Re: xls 2003-file not in a recognizable format

This worked for me since I have xls files from long ago, when the newer version's don't see it as compatible file then it time to open up a gmail(google) account and upload the file to it and view it though them ^^ Then after it saved then downloaded it as what ever formate you want then it will work on your pc again .. Google rocks when it comes to compatibilities ^__^
Reply With Quote
  #8  
Old 03-03-11, 12:29
shnerdly's Avatar
shnerdly shnerdly is offline
Major Geek
 
Join Date: Jan 2006
Location: The Frozen Tundra of Minnesota
Posts: 1,060
Thanks: 46
Thanked 125 Times in 119 Posts
Default Re: xls 2003-file not in a recognizable format

I would suggest trying OpenOffice. It's pretty good at determining what filters it needs to open most files.
__________________
Communicate! . . . It can't make things any worse.
Reply With Quote
  #9  
Old 03-03-11, 16:45
GCWesq GCWesq is offline
Major Geek
 
Join Date: Jun 2008
Location: Lilydale, Victoria, Australia
Posts: 1,041
Thanks: 95
Thanked 108 Times in 98 Posts
Default Re: xls 2003-file not in a recognizable format

Hopefully one of the suggestions provided will work. At any rate, it appears that the problem is either with the computer where the file was generated, or it got corrupted in transit.
If you have any doubts at all about the version of Excel that created the file, you could (in Windows Explorer) put an 'x' after the '.xls' to give '.xlsx', then try opening it on the computer with the converter on it.
Have you saved the file? If so, you would have another copy of it in the email in which it was sent (or was it given to you on a flash drive, in which case you would have a copy there).
The person who sent you the file would also have a copy of it (if it was emailed, there would be a copy in their Sent Items box as well). Can they open it OK? Can they give it to you again?
Reply With Quote
  #10  
Old 03-05-11, 09:40
angelia angelia is offline
Private E-2
 
Join Date: May 2010
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
Default Re: xls 2003-file not in a recognizable format

Hi there and thank you very much for your time and answers.

Unfortunately, no good luck so far to recover the data from the xls file.

I am still waiting for the results of the online converter, as suggested by sach2.

Uploading the file on my gmail account, allows me to view it only in plain html and in gibberish.

OpenOffice gives me gibberish too.

Adding an x at the extension of the file, I am able to open the file using the converter but in gibberish again.

The xls file was created with Excel 2003. The file got damaged during saving and it reached me already damaged. Unfortunately there is no other copy of the file so I can have access to the original content.

I would appreciate any suggestion

Thank you
Reply With Quote
Sponsored links
  #11  
Old 03-05-11, 17:16
GCWesq GCWesq is offline
Major Geek
 
Join Date: Jun 2008
Location: Lilydale, Victoria, Australia
Posts: 1,041
Thanks: 95
Thanked 108 Times in 98 Posts
Default Re: xls 2003-file not in a recognizable format

Do you need a working worksheet, with formulae, etc, or do you just need the values? A lot of the suggestions below will only give you the values.

There are some suggestions on how you might recover the file here (some of these won't apply, but you might find something useful):
http://www.wikihow.com/Recover-a-Corrupt-Excel-File

More suggestions here (including some of the above) here:
http://www.pruittfamily.com/paul/excel.htm

Have you tried:
  1. Open Excel
  2. On the File menu, click Open.
  3. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
  4. Click Open and Repair, and then choose which method you want to use to recover your workbook.
You may also be able to get the data from the file using a macro, as explained here:
http://support.microsoft.com/kb/300643

There's another suggestion here:
http://technet.microsoft.com/en-us/l.../cc751043.aspx

You might also try sending it back to the sender and see if they can open it.

Try the free Microsoft Excel Viewer:
http://www.microsoft.com/downloads/e...displaylang=en

Also try this (similar to an earlier suggestion:
In a new Excel worksheet, you can try linking to the corrupt workbook and pull the data out. You need to save the Excel file somewhere first, if not already done:
  1. Start Excel.
  2. From the File menu, Select Open. Browse to the folder with the corrupt file, then click Cancel.
  3. Select File | New.
  4. In Cell A1, enter =FileName!A1. Where FileName is the name of your corrupt file. If the "Select Sheet" dialog box appears, select the appropriate worksheet and click OK.
  5. Copy Cell A1 to the cells with the data you want to pull from the corrupt workbook.
Now post back and say the Online Converter worked...
Reply With Quote
  #12  
Old 03-05-11, 19:48
plodr's Avatar
plodr plodr is online now
Major Geek Extraordinaire
 
Join Date: Sep 2007
Location: at my computer
Posts: 14,307
Thanks: 204
Thanked 2,599 Times in 2,407 Posts
Default Re: xls 2003-file not in a recognizable format

Quote:
The file got damaged during saving and it reached me already damaged.
With that information, I think you will continue to see nonsense instead of an actual file.

Unfortunately, the person who created the file and damaged it when saving it, will have to re-do it to get a readable version.
__________________
7" ASUS eeepc lubuntu 14.04
Aspire V5 7 HomePremium
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 - why do cell contents change format? sharpconnect Software 3 11-05-10 04:41
Recognizable via flash Binaryfreek Software 1 02-05-10 04:30
Canon A75 no longer recognizable Win XP USB zapp Hardware 3 09-04-07 08:53
Word 2003 format in Outlook 2003 firetech Software 1 11-01-04 09:00
Hard Drive not recognizable! luma13 Hardware 7 05-25-04 23:39


All times are GMT -5. The time now is 11:29.

MajorGeeks.Com Menu

MajorGeeks.Com \ All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ NEW! PC Games \ System Tools \ Macintosh \ Demonews.Com \ Top Downloads

MajorGeeks.Com \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds


All content Copyright MajorGeeks.com source code Powered by vBulletin® Version 3.8.4
Copyright © 2009 vBulletin Solutions, Inc. All rights reserved.
Ad Management by RedTyger