File format and extension don't match: Excel 2013


I am trying to follow the "Getting Started with Excel-DNA" procedure and every time I open the Test1.xll file I get an error "File format and extension don't match". I have the option to proceed; however, when I do the worksheet just populates with random characters. I have attached a screenshot to show what is happening.

I am using Excel 2013 with Windows 7. I have the .NET 3.5.1 runtime installed and I have macro security set as low as it will go. http://imgur.com/gj3UoZk
Closed Sep 5, 2013 at 8:11 PM by govert
I'm not sure how to trace this further. Apart from the 64-bit case, I don't know of other cases where this problem has occurred.


govert wrote Jul 18, 2013 at 9:53 AM

You probably have the 64-bit version of Excel installed, and need to open the ExcelDna64.xll instead. (Or copy ExcelDna64.xll to Test1.xll).

You can check your Excel version by going to File->Account, Click 'About Excel' and look at the first line.

nickvise wrote Jul 18, 2013 at 11:23 AM

It says I have the 32-bit version of Excel on that about page. Either way, when I try to open either version of the ExcelDna.xll file I get the same result. Anything else I can check? I am really excited to use this tool.

govert wrote Jul 18, 2013 at 11:48 AM

Some more things you can check:
  1. Are you using the current release version of Excel-DNA (version 0.30)?
  2. Can you try to load the ExcelDna.xll sample in the Distribution folder (either double-click on it, or File->Open)?
  3. Is VBA installed in your Excel (check by just pressing Alt+F11 and verifying that the VBA IDE is displayed)?
  4. Do you have an unusual anti-virus program installed?