Why won't Excel 2013 work as an "Open With..." program in Windows 7?

7

I just recently uninstalled Office 2010 32-bit and installed Office 2013 64-bit on my computer. I was sent some text files that are tab-delimited, so I want to open them with Excel.

I am trying to add Excel to the Open With... option in the right-click menu in Windows 7. Every time I try, I open the selection screen, browse to Excel.exe in the Office15 folder and press OK, but it refuses to stay as an option on the selection screen.

I know that I can open Excel and then open the file, or even drag-and-drop it onto Excel, but seeing as I'll be opening a lot of these files over the next few weeks, I'd really rather add it to the right-click menu (like I used to do all the time).

Any ideas as to why it won't allow me to open that way or how to fix it?

techturtle

Posted 2013-04-03T00:18:21.530

Reputation: 8 059

do you want to open that type of file with excel all the time? – Dilshod – 2013-04-03T00:52:13.987

Not really, because they are all .TXT which I normally open with Notepad++. However, I have tried that and it won't allow me to even make it the default program. Excel simply won't be allowed in the Open With window at all, for some reason. – techturtle – 2013-04-03T00:54:21.637

so it worked before and stop working after installing Office 2013? – Dilshod – 2013-04-03T00:58:27.063

Can't say 100% that it used to work on this machine, but I know that I have the same basic setup at work (Win7x64, similar other installs) but still with Office 2010 and it does work there. – techturtle – 2013-04-03T01:02:41.560

how did it go ? – Dilshod – 2013-04-03T01:18:34.563

try WINWORD.EXE see if it works. – Dilshod – 2013-04-03T01:34:02.383

Answers

13

Finally figured it out. It was directly related to the switch from 32-bit to 64-bit. Poking around the registry I found the following key was wrong:

HKEY_CLASSES_ROOT\Applications\EXCEL.EXE\shell\open\command\(Default)

Within this key was the following "old" value:

"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" "%1"

When I changed it to the correct, new location for Excel, it started working immediately.

"C:\Program Files\Microsoft Office\Office15\EXCEL.EXE" "%1"

techturtle

Posted 2013-04-03T00:18:21.530

Reputation: 8 059

Awesome. Utterly helpful. I observed that when I correct the path in HKEY_CURRENT_USER (due to missing admin privileges), the erroneous path in HKEY_CLASSES_ROOT also changes. Not sure why Windows is even allowing that... – Inarion – 2019-09-12T13:28:21.717

3

you're right on the mark, but mileage may differ..

That is, the correct registry value in my case is:

"C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE" "%1"

And yes, it started working right away. Awesome!

Jan

Posted 2013-04-03T00:18:21.530

Reputation: 41

This path was correct in my case as well. +1 – djv – 2015-09-01T15:31:19.443

While @teylyn is technically correct, your answer is also helpful. Thanks for clarifying techturtle's answer. – PowerUser – 2016-02-08T20:41:39.597

Please don't post comments as answers. Your contribution is not an answer. If you want to post a comment, earn the 50 rep required. Until then, just hold that thought. – teylyn – 2013-05-11T09:14:16.190

1

Press Win+R and type regedit. Then open this:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\FileExts\.txt\OpenWithList

and add new value in that place. there must be a, b, ... so you name your value c if you have a,b. Put this text "EXCEL.EXE" without quotes into a value data and see if this work.

Bee careful with registry things!

Dilshod

Posted 2013-04-03T00:18:21.530

Reputation: 349

I figured there would be a place like this in the registry, but didn't know where to find it. Unfortunately, this won't work because I already had EXCEL.EXE in there (at position C) and it's still not in my right-click menu. – techturtle – 2013-04-03T01:20:32.300

ok then try deleting it from there and add it again(do not add from registry). – Dilshod – 2013-04-03T01:22:00.720

Got it working eventually. +1 because your solution should work for most people and for sticking with me trying to fix this. Thanks! – techturtle – 2013-04-03T02:11:13.977

0

Similar issue here. Office 2007 was installed. Installed Office 2013 as well so that Publisher 2007 could still be used. Excel documents kept opening in Excel 2007 no matter how I changed the associations.

I found that running a Quick Repair on the Office 2013 installation resolved the issue.

Maka

Posted 2013-04-03T00:18:21.530

Reputation: 1

Can you expand upon this? An explanation of this procedure would make this answer more useful. – bwDraco – 2016-01-29T13:02:37.593

0

It works for me but in different way. I have changed it from

"C:\Program Files\Microsoft Office\office14\EXCEL.EXE" "%1"

to

"C:\Program Files\Microsoft Office\office15\EXCEL.EXE" "%1"

Sandip

Posted 2013-04-03T00:18:21.530

Reputation: 1

0

I had a similar problem except mine was with PowerPoint 2013.

A work computer had Office 2007 installed on it and needed to keep Outlook 2007 on the computer, so I did not uninstall Word, Excel or PowerPoint 2007. I then installed Office 2013 thinking it would default to the newest version. However this was not the case and no matter how many times I choose to "open with" PowerPoint 2013 and set it to the default open program, it would always open in 2007.

The trick was as techturtle described above except there was no POWERPNT.EXE key in the registry.

I had to go to:

HKEY_CLASSES_ROOT\Applications\

then:

  • right click on the "Applications" folder and choose new and then choose key and type "POWERPNT.EXE"
  • do this again, new key "shell"
  • new key "command"
  • new key "open"

so I created my own registry key for POWERPNT.EXE that looked like this

HKEY_CLASSES_ROOT\Applications\POWERPNT.EXE\shell\open\command\(Default)

Once that was done I placed the location of the PowerPoint 2013 executable in the (Default) key. Which for me was:

"C:\Program Files\Microsoft Office 15\root\office15\POWERPNT.EXE" "%1"

* Update November 2014 *

I found recently that Windows did an update in early November 2014 that reverted everything back to Office 2007 as the default program again. This time I had to create the registry values for PowerPoint, Excel and Word as mentioned above. Once they were created, documents would still default to Office 2007. The final trick was to right click -> open with -> choose default program -> choose Office 2013 program. After creating the registry values you will find this option available.

user2722071

Posted 2013-04-03T00:18:21.530

Reputation: 1