none
Excel .Net programmability feature

    Question

  • It seems that the latest version of the PoweQuery requires Excel to be installed with ".Net programmability features enabled". Is this right? There is nothing about it in the prerequisites. The last thing I want to do now is to reinstall my Excel.
    Tuesday, November 12, 2013 3:59 PM

Answers

  • The way how I solved it was by uninstalling older versions of MS Office - I had 2013 version with some Office applications from 2010 (MS Access). Once I uninstalled all 2010 apps, I was able to install PowerQuery correctly. I hope it helps.
    • Marked as answer by Farquaad01 Thursday, January 09, 2014 3:11 PM
    Thursday, January 09, 2014 3:10 PM
  • Hi,

    This hasn't changed in latest versions of Power Query. You can re-enable this option via the Add/Remove Programs menu, by clicking in your Office entry in the list and clicking "Repair".

    Thanks,
    M.

    Monday, November 18, 2013 10:05 PM

All replies

  • Hi,

    This hasn't changed in latest versions of Power Query. You can re-enable this option via the Add/Remove Programs menu, by clicking in your Office entry in the list and clicking "Repair".

    Thanks,
    M.

    Monday, November 18, 2013 10:05 PM
  • Hello Miguel,

    This option not run :(. it may be the version of office? Before working well

    Regards


    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Tuesday, January 07, 2014 9:59 PM
  • I have win 64 bit o/s, Excel 2013 and other office prods are 2010.  I tried the add/remove feature to add .NET Programmability and it worked BUT the latest installation package of Power Query 2.9.xxx does not see it and keeps asking me to install it.  Does this require a complete re-installation?????

    Thursday, January 09, 2014 2:06 PM
  • The way how I solved it was by uninstalling older versions of MS Office - I had 2013 version with some Office applications from 2010 (MS Access). Once I uninstalled all 2010 apps, I was able to install PowerQuery correctly. I hope it helps.
    • Marked as answer by Farquaad01 Thursday, January 09, 2014 3:11 PM
    Thursday, January 09, 2014 3:10 PM
  • I'm curious: how many of the people having this problem are using 64-bit Excel vs 32-bit Excel?
    Thursday, January 09, 2014 4:22 PM
  • 32 bit
    Thursday, January 09, 2014 4:30 PM
  • The way how I solved it was by uninstalling older versions of MS Office - I had 2013 version with some Office applications from 2010 (MS Access). Once I uninstalled all 2010 apps, I was able to install PowerQuery correctly. I hope it helps.

    Correct Farquaad01. I have unistalled office 2010 and working properly ^^. Thanks a lot

    Regards


    Fran Díaz | twitter: @frandiaz_ | Blog: {geeks.ms/blogs/fdiaz/} | Communities: {onobanet.es} & {secondnug.com}

    Thursday, January 09, 2014 4:48 PM
  • The way how I solved it was by uninstalling older versions of MS Office - I had 2013 version with some Office applications from 2010 (MS Access). Once I uninstalled all 2010 apps, I was able to install PowerQuery correctly. I hope it helps.

    Windows 8.1 x64 with Office Professional Plus 2013 x86. I too initially tried a repair followed by a reboot. It was only after I removed Office 2010 (followed by another reboot) that Power Query 2.9.3547.162 was able to be installed.

    I don't think I had any of the main Office 2010 applications installed, just components that may have been installed by another application. Guess I'll find out when something doesn't work.

    Thanks for the solution.

    Friday, January 17, 2014 11:16 PM
  • Same issue, just added .net programmability in Office 2010 for the Excel (even if Excel 2010 is not installed, have only few components from Office 2010) installation, was able to install Power Query (2.11.3625.144) after that. Windows 8.1, Office365ProPlus, everything x64.
    Thursday, May 15, 2014 12:01 PM