How To Install PowerOLAP Add-Ins Manually
There are two PowerOLAP add-ins that you will need to manually add: PowerOLAP Core.xll and PowerOLAP.xla.
You will first need to add PowerOLAP Core.xll. In order to determine where it is located you must first determine whether you are using 32-bit Excel or 64-bit Excel. In Excel, go to File->Account->About Excel and you will see the below screen:
Now that you know which version you are using, go to File->Options-Add-Ins and you will see the below screen:
Click ‘Go’ and then ‘Browse’ and you will browse to the location of the file. If you are using 32-bit Excel, the path will be: C:\Windows\SysWOW64\PowerOLAP Core.xll. If you are using 64-bit Excel, the path will be: C:\Windows\System32\PowerOLAP Core.xll.
After adding this, your PowerOlap version will determine which add-in to browse for next.
Version 16 or below:
we now want to add the PowerOLAP.xla.
Go to File->Options-Add-Ins->Go->Browse again and this time the file is located at C:\Program Files (x86)\PowerOLAP\PowerOLAP.xla (this is the default PowerOLAP directory location).
Version 18 or higher:
we now want to add the Powerolapaddin.xlam.
Go to File->Options-Add-Ins->Go->Browse again and this time the file is located at C:\Program Files (x86)\PowerOLAP\Powerolapaddin.xlam (this is the default PowerOLAP directory location).
With both add-ins added you should be all set to use PowerOLAP with Excel.