Problems Setting Opening .xml Files by Default with Excel

System Information

 Time of this report: 10/31/2017, 02:36:27 Machine name: DESKTOP-MGQM9CI Machine Id: {37EDB72E-177E-47F5-9240-290B8767FFE4} Operating System: Windows 10 Home 64-bit (10.0, Build 15063) (15063.rs2_release.170317-1834) Language: English (Regional Setting: English) System Manufacturer: MSI System Model: MS-7885 BIOS: Default System BIOS Processor: Intel(R) Core(TM) i7-6800K CPU @ 3.40GHz (12 CPUs), ~3.4GHz Memory: 16384MB RAM Available OS Memory: 16284MB RAM Page File: 5278MB used, 13438MB available Windows Dir: C:\WINDOWS DirectX Version: DirectX 12 DX Setup Parameters: Not found User DPI Setting: Using System DPI System DPI Setting: 96 DPI (100 percent) DWM DPI Scaling: Disabled Miracast: Available, with HDCP 

Microsoft Graphics Hybrid: Not Supported DxDiag Version: 10.00.15063.0000 64bit Unicode

---

I'm having trouble associating .xml files with Excel 2016. I tried previously through the "open with" option when I right clicked and got the icon to show. I noticed it looked a little different:

http://ift.tt/2ihNJq2

It doesn't work when I double click it and it gives me the following dialog:

http://ift.tt/2gQJPUw

I tried it again and chose Microsoft Excel (not Excel 2016) because it's the one located in C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE

http://ift.tt/2ii6ae0

I can open this .exe file without a problem so it should work, right? Nope. It gives me the same error as when the odd looking Excel icon was default.

So I try to change default file associations through the OS by changing .xml associations to the C:\Program Files (x86)\Microsoft Office\root\Office16\EXCEL.EXE location:

http://ift.tt/2gP1rQP

http://ift.tt/2ihNKu6

http://ift.tt/2gQJQry

The icon changes to the following:

http://ift.tt/2ihNL18

And when I double-click to open it, it still doesn't run. Nothing happens. I have to manually open files from within Excel and I have no idea how to solve this problem. I don't have to manually open approximately 300 .xml files so I can transfer them into a single .xls file. I have 4 days to do this and I don't want to waste time opening files.

TL;DR: I want to associate .xml files with Excel but Windows 10 makes it difficult.

Submitted October 31, 2017 at 03:11PM by resorcinarene http://ift.tt/2gPPt9y