Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot open xlsx files

Posted on 2013-12-04
5
Medium Priority
?
1,442 Views
Last Modified: 2014-03-29
A relative of mine has a computer running Windows Vista (64-bit) which has Office XP (which I think is Office 2002). I know that beginning with Office 2007, the default file extensions for Word, Excel and PowerPoint are docx, xlsx and pptx, respectively, and that prior versions of Office cannot open those files unless they install the Office Compatibility Pack.
     This relative was recently emailed some docx and xlsx files. I installed the Office Compatibility Pack and now they can open the docx files. But they still cannot open the xlsx files; when they try they get an error message saying "This file is not in a recognizable format" and then Excel opens but its full of gibberish (see screen-shot).
     I thought maybe they needed to have have Office Service Pack 3 installed. I checked Windows update but it said there were no updates available, which made me think I must already have it installed. But just to be sure I installed the service pack anyway. No change.
     Why can't they open xlsx files?
ExcelGibberish.doc
0
Comment
Question by:john8217
4 Comments
 
LVL 99

Expert Comment

by:John Hurst
ID: 39697242
Back in those ancient days, Windows Updates and Office Updates were separate. There are 3 Service Packs for Office XP (all downloadable) and I think you can go the an Office XP tool and run Updates under Help or something like that.

So look for updates in Office XP and then look also for Microsoft Update on the XP machine in IE 8 as it is possible Microsoft Update (distinct from Windows Update) may run the Office Update.

Make sure Office is up to date.

Also run an Office Repair from within one of the Office applications.

... Thinkpads_User
0
 
LVL 4

Expert Comment

by:andrew_man
ID: 39697318
minimize use office 2003 and Microsoft Office Compatibility Pack for office 2003
0
 
LVL 2

Accepted Solution

by:
colin_Paul earned 750 total points
ID: 39711106
Hello John8217,

I want to ask one thing that when you are going to save your copy, do you have receive any alert message to overwrite or saving existing file , if yes which option you have choose yes or no.. Might be it is possible that you have select no option that's why this issue get encountered and you are facing this issue.

Now you can recover your word file by following simple steps.

Open the Office 2010 applications that you were using.
Click on File tab -> Recent.
Click Recover Unsaved Documents if you are in Word 2010, Recover Unsaved Workbooks if you are in Excel 2010 or Recover Unsaved Presentations if you are in PowerPoint 2010.

Your saved drafts folder will open in a new window. Select the file and then click Open.
In the business bar at the top of the file, click Save As to save your file to your computer.

Another way to acess unsaved file is given below:-


Open the Office 2010 application you were using.
Open a new file or any existing file.
Click the File tab.
Click Info.
Click Manage Versions.
Click Recover Unsaved Documents if you are in Word 2010, Recover Unsaved Workbooks if you are in Excel 2010 or Recover Unsaved Presentations if you are in PowerPoint 2010.

You will see the list of your unsaved files. Select the file and click Open.
In the business bar at the top of the file, click Save As to save your file to your computer.

Source(s):
http://blogs.msdn.com/b/mssmallbiz/archive/2012/04/20/how-to-recover-that-un-saved-microsoft-office-excel-word-or-powerpoint-file-you-closed-before-saving.aspx

Thanks
Colin Paul
0
 

Author Closing Comment

by:john8217
ID: 39729625
Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
It is a real story and is one of my scariest tech experiences. Most users think that IT experts like us know how to fix all computer problems. However, if there is a time constraint and you MUST not fail the task or you will lose your job, a simple …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question