PowerExcel Installation
- Download Power Excel
- Right click on installation file and run as administrator
- Proceed to click next
- Accept license agreement and proceed to click next
- Accept the software maintenance agreement and proceed to click next
- Proceed to click install
- You will be prompted to install the Microsoft office customization, proceed to click install (Note this is compulsory)
- Click finish
Open the Excel > Go to Options > Add-ins > click Go at the bottom
- Go to the Excel Add-ins and untick the Olation4XL.ExcelFunctions.OlaFunctions add in. You might be prompted to remove it from the list as it cannot find the file. Click on yes
- Select Automation
- This will bring up to the Automation servers dialog box. Proceed to search for “PowerExcel.ExcelFunctions”. Select proceed to click OK
- Tick the checkbox for PowerExcel.ExcelFunctions then proceed to click OK
- Close Excel