It is INSANE that this thread I started still gets people coming over 5 years later. 

For me, ensuring that both programs were 64bit did the trick. I'm unsure why Intuit supports these features, but doesn't actually make sure they work with all the different versions of Microsoft Excel. You'd think they'd make it so it exported to an .xlsx file regardless of what programs you have installed on your PC.