Open MS Excel and go to: File > Options > Add-ins and click Go… at the bottom of the screen. (see below)
- In the next screen select Automation. (See below)
- This will bring you to the Automation servers window where you will search for “PowerExcel.ExcelFunctions”. Select it and click OK. (See below)
- This will take you back to the previous window where you will see that “PowerExcel.ExcelFunctions” will be selected. Then click OK. (See Below)
- Your Power Excel Add-in is now installed and you will see it at the top of your Microsoft Excel Ribbon.