Excel 2013 / 2016 does not open XML files from SharePoint


Overview:

You have Excel files in .XML format (XML Spreadsheet 2003) and you get error

"This action couldn't be performed because Office doesn't recognize the command it was given."

When you try to open the file from a SharePoint document library.

There will likely not be a product change to address this issue, it is recommended that the issue is worked around.

Workaround:

Deploy a registry key based fix, depending on the version and bitness of Office Installed the registry changes will vary.

**Warning, editing the registry can have harmful side effects if not done property, use this workaround at your own risk.

Registry file content will be in-between the ---- markers

----Office 2013 MSI 32 bit ---

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.xml\OpenWithList\excel.exe]
@=""
[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]
@="\"C:\\Program Files (x86)\\Microsoft Office\\Office15\\EXCEL.EXE\" /n \"%1\""
[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]
".xml"=""

---End Office 2013 MSI 32 bit ---

----Office 2016 MSI 32 bit ---
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.xml\OpenWithList\excel.exe]
@=""
[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]
".xml"=""

----End Office 2016 MSI 32 bit ---

----Office 2016 MSI 64 bit ---

Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.xml\OpenWithList\excel.exe]
@=""
[HKEY_CLASSES_ROOT\Applications\excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_CLASSES_ROOT\Applications\excel.exe\SupportedTypes]
".xml"=""

----End Office 2016 MSI 64 bit ---

----Office 2016 C2R 32 bit ---
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Applications\Excel.exe]
"FriendlyAppName"="@C:\\Program Files\\Microsoft Office\\root\\VFS\\ProgramFilesCommonX86\\Microsoft Shared\\Office16\\oregres.dll,-206"
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell]
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit]
@="@C:\\Program Files\\Microsoft Office\\root\\VFS\\ProgramFilesCommonX86\\Microsoft Shared\\Office16\\oregres.dll,-1"
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_CLASSES_ROOT\Applications\Excel.exe\SupportedTypes]
".xml"=""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\SupportedTypes]
".xml"=""
[HKEY_CLASSES_ROOT\.xml\OpenWithList\Excel.exe]
@=""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\.xml\OpenWithList\excel.exe]
@=""
----End Office 2016 C2R 32 bit ---
----Office 2016 C2R 64 bit ---
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\.xml\OpenWithList\Excel.exe]
@=""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\.xml\OpenWithList\excel.exe]
@=""
[HKEY_CLASSES_ROOT\Applications\Excel.exe]
"FriendlyAppName"="@C:\\Program Files\\Microsoft Office\\root\\VFS\\ProgramFilesCommonX64\\Microsoft Shared\\Office16\\oregres.dll,-206"
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell]
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit]
@="@C:\\Program Files\\Microsoft Office\\root\\VFS\\ProgramFilesCommonX64\\Microsoft Shared\\Office16\\oregres.dll,-1"
[HKEY_CLASSES_ROOT\Applications\Excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_CLASSES_ROOT\Applications\Excel.exe\SupportedTypes]
".xml"=""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\shell\edit\command]
@="\"C:\\Program Files\\Microsoft Office\\Root\\Office16\\EXCEL.EXE\" /n \"%1\""
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Applications\excel.exe\SupportedTypes]
".xml"=""
----End Office 2016 C2R 64 bit ---

Comments (0)

Skip to main content