If you use Power Pivot and Power Query, it is necessary to download and install these plug-ins as a standard .EXE application in Microsoft Excel 2010. I focus on direct download links and short steps how to do.
Power Pivot
https://www.microsoft.com/en-us/download/details.aspx?id=43348
Power Pivot should automatically appear as a tab if you run Excel again. If not, then you need to install Visual Studio 2010 Tools for Office Runtime:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=48217
and then go to File> Options> Add-ins and right-click COM Add-ins and choose Go ... and then check PowerPivot for Excel, picture:
Power Query
The next installation refers to Power Query, which requires a minimum of Service Pack 1 (a 64-bit version) or Service Pack 2 (a reference to a 64-bit version) for Microsoft Excel 2010.
Power Query can then be downloaded from this link:
https://www.microsoft.com/en-US/download/details.aspx?id=39379
For over 11 years Jan Zitniak has been a professional instructor concentrating on Microsoft Office. He holds an international Microsoft Excel – Office Excel ® 2010 Expert certificate and has written several books discussing Microsoft Office.
