PowerExcel Installation

  1. Download Power Excel 
  2. Right click on installation file and run as administrator
     Graphical user interface, text, application

Description automatically generated 

 

 

 

  1. Proceed to click next

     Graphical user interface, text, application

Description automatically generated

 

  1. Accept license agreement and proceed to click next

Graphical user interface, text

Description automatically generated

 

  1. Accept the software maintenance agreement and proceed to click next

     Graphical user interface, text

Description automatically generated

 

 

 

  1. Proceed to click install

     Graphical user interface, text, application, email

Description automatically generated 
  2. You will be prompted to install the Microsoft office customization, proceed to click install (Note this is compulsory)

     Graphical user interface, application

Description automatically generated

 

  1. Click finish

     Graphical user interface, text, application

Description automatically generated

 


Open the Excel > Go to Options > Add-ins > click Go at the bottom

  1. Text

Description automatically generated
     

 

 

 

 

 

 

 

 

 

 

 

 


 

  1. 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
     

 

  1. Select Automation

     Graphical user interface, text, application

Description automatically generated

 

  1. This will bring up to the Automation servers dialog box. Proceed to search for “PowerExcel.ExcelFunctions”. Select proceed to click OK


 Graphical user interface, text, application

Description automatically generated 

 

  1. Tick the checkbox for PowerExcel.ExcelFunctions then proceed to click OK

Graphical user interface, text, application

Description automatically generated

 

  1. Close Excel