Excel 2010 can't open .xlsx files

Wolf
Wolf used Ask the Experts™
on
I've upgrade office 2007 to office 2010

After the upgrade i am unable to open any .xlsx files using excel

I have a number of .xlsx files on my desktop and windows doesn't know which program to use to open them.  If i open excel first and go to open and then point to the files, they open fine, just not when i double click on the files directly.

If i create and save a new excel spreadsheet in the default settings as .xlsx it saves it fine but then doesn't know which program to open it in.

This is only happening in Excel, Word files are fine.

I'm using Windows 7

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Yeah, it looks like you lost the "file associations" during the uninstall/reinstall
Here is an article on how to fix this:  http://support.microsoft.com/kb/307859
Specifically, Excel 2010 uses:   "C:\Program Files\Microsoft Office\Office 14\Excel.exe" /dde
TracyVBA Developer

Commented:
To change the file association, try this:

Open Control Panel > Control Panel Home > Default Programs >  Set Associations. Select the Excel file type in the list and click Change  Program, then select Excel 2010.

Author

Commented:
When i go to control panel > default programs i find xlsx and it says Unknown program.  So i then click Change program and it comes up with the Open with dialog box
Excel isn't listed so i go into Browse, and navigate to the excel.exe and click open.  However, nothing then happens, it just goes back to the open with dialog box and excel isn't listed
Any ideas?
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

TracyVBA Developer

Commented:
You could try to do a repair on Office.  Something may have been messed up during installation.  

I'd suggest doing the repair, then rebooting, and then trying to reset the file association.

Author

Commented:
Ok...
I've tried doing a repair on Office 2010, installing all the latest updates, and rebootings - it hasn't fixed it.
When i trying to chose the file association it will show word, access, visio 2010 etc but doesn't show Excel as an option.  When i try to browse to it, it just doesn't do anything.
I completely removed Office 2007, rebooted, and then installed Office 2010 from scratch
It's the 64 Bit edition
Any other ideas?
TracyVBA Developer
Commented:
Can you try recreating the profile, it may have gotten corrupted.  You could also try logging on as a different user first, to see if works under a different profile.

Commented:
did you try the string that I provided (with the /dde at the end)?
"C:\Program Files\Microsoft Office\Office 14\Excel.exe" /dde
Note: change the path to whatever your install path is...
Commented:
If you are comfortable about editing the registry, you might want copy-n-paste the attached into a file (with a *.reg extension), and then just double-click on it to install it.  I exported this from the registry on my Win7 / Office 2010 PC.
 

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\.xlsx]
"Content Type"="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
@="Excel.Sheet.12"
"PerceivedType"="document"

[HKEY_CLASSES_ROOT\.xlsx\Excel.Sheet.12]

[HKEY_CLASSES_ROOT\.xlsx\Excel.Sheet.12\ShellNew]
"FileName"="excel12.xlsx"

[HKEY_CLASSES_ROOT\.xlsx\PersistentHandler]
@="{4887767F-7ADC-4983-B576-88FB643D6F79}"

[HKEY_CLASSES_ROOT\.xlsx\ShellEx]

[HKEY_CLASSES_ROOT\.xlsx\ShellEx\PropertyHandler]
@="{993BE281-6695-4BA5-8A2A-7AACBFAAB69E}"

[HKEY_CLASSES_ROOT\.xlsx\ShellEx\{8895b1c6-b41f-4c1c-a562-0d564250836f}]
@="{00020827-0000-0000-C000-000000000046}"

[HKEY_CLASSES_ROOT\.xlsx\ShellEx\{BB2E617C-0920-11d1-9A0B-00C04FC2D6C1}]
@="{C41662BB-1FA0-4CE0-8DC5-9B7F8279FF97}"

Open in new window

Author

Commented:
Thanks!

When i logged in as a different user it worked fine, so it was my profile but i really didn't want to recreat my profile

I ran the reg fix and after a reboot it would now let me choose excel as an option to open .xlsx files which is great!

Thanks very much for the help :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial