In Versions before 6.0. The DataPA option for Excel was an 'Add-In' that Appeared under the 'Add-ins 'Menu item.


From Version 6.0 onwards the DataPA option for Excel is now a Toolbar item that appears as a Main Excel Item named 'DataPA OpenAnalytics Excel Addin'.


The screenshot below shows a standard Excel Toolbar, displaying the New DataPA Excel Application Options,



clip0115


The Help Manual Page for the Excel Toolbar is available here.



If this toolbar is not available then it can usually be found in the Excel Options - AddIns.  Please ensure that there is only 1 instance of Excel running when add-ins are amended.


The Add-In may appear in in the Section "Inactive Application Add-ins



In this Situation select "COM Add-ins" from the Manage Drop down list then Press Go



Ensure the 'DataPA OpenAnalytics Excel Addin' is selected then Press Ok.  This will add the Add in to the Excel Toolbar. 



If the 'DataPA OpenAnalytics Excel Addin' shows under the Disabled Items section. Select "Disabled Items" from the Drop down, The Select the Addin in from the list of Disabled Items and press the Enable Button. 






If you cannot see the DataPA OpenAnalytics Excel Addin Toolbar listed. The best option is to run a repair of the DataPA installation, If this is not possible then there is a VSTO Deployment file ('DataPA OpenAnalytics Excel Addin.vsto') in the "Program Files (x86)\DataPA\Excel folder.  This file can be run by Double-clicking, or right-click and select Open.