The following instructions are based on Microsoft Office 2014 and higher. The functions that where Tools menu prior to 2007 have moved to the File|Option within Excel, in Excel 2007 the Options button is found on the Excel Office button.
If you are unsure, please check the Excel help file that is installed with office.
PaXcel has two components, an XLA file that contains access to the PaXcel formulas a COM DLL that contains the Excel toolbar and also the functions themselves.
The PaXcel add-in will normally be added as part of the install if you receive any error messages, or the functions are not giving the results expected, then you should check that the Add-in exists and has been loaded.
|
Start a new worksheet and select the File menu |
|
Select the Options menu to display the Excel Options screen and then select the Add-ins option as shown below. Make sure that the Manage option is set to Excel Add-ins and then press the Go button to display the active/available add-ins. If the PaXcel is not ticked then tick the box to make it active. If it is not listed then press the Browse button to locate the XLA which will be located in the c:\pdi spirit\paxcel folder unless you selected a different location to install the application.
COM Add-in: If the PaXcel.dll file is not listed in the Active applications then you should re-install PaXcel as the DLL has not registered correctly. If it still does not show please contact PDi Support for additional help. (Normally this helps if the installs is not installed with raised privileges).
|
