Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Cannot open xlsx files

Posted on 2013-12-04
5
1,377 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
5 Comments
 
LVL 93

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 250 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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

809 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