\n<\/strong><\/p>\n
Open Excel. Click the \u2018File\u2019 tab in the ribbon and select \u2018Options\u2019 in the left hand menu.<\/p>\n
This should launch the Excel Options Window. In the left hand pane, choose Add-ins which will bring up the list of installed add-ins and whether they are active (enabled) or not.<\/p>\n
Initially the IA Data Manager may be in the list but it will not be active. To activate it, click the \u2018Go…\u2019 button at the bottom of the add-in screen in order to start managing your add-ins.<\/p>\n
If the IA Data Manager is not present in the Add-Ins dialog, click \u2018Browse…\u2019 and browse to the file called \u2018IA Data Manager.xla\u2019 which is located in the root folder of the InstantAtlas Desktop installation, usually \u2018C:\\Program Files\\EsriUK\\InstantAtlas\u2019, and click OK. It will now be available in the list of Add-Ins.<\/p>\n
Select the InstantAtlas Data Manager from the checklist and click \u2018OK\u2019.<\/p>\n
If you have multiple versions of the add-in available because you have upgraded from a previous version of InstantAtlas, please ensure that the most recent version has been enabled.<\/p>\n You will now need to close and then reopen Excel.<\/p>\n The add-ins tab should now display three new buttons. There is also a menu item called InstantAtlas from which these functions can also be selected.<\/p>\n This section of the user guide documents the \u2018IA Export\u2019 button. The \u2018IA Merge Files\u2019 button is used to create data files for multiple geography reports. Section \u2018Multiple Geography Reports<\/a>\u2019 of this user guide gives detailed information on how to create multiple geography reports. The \u2018IA Export for RB+\u2019 button can be helpful for those customers, who are using the InstantAtlas cloud service <\/span>apps Dashboard Builder or Report Builder and have their data already in an Excel workbook correctly formatted for InstantAtlas Desktop. Please refer to the following help pages for further information:<\/p>\n If you want to deactivate the add-in you should do the following:<\/p>\n Excel 2016 and later<\/strong><\/p>\n 1. In Excel click the \u2018File\u2019 tab and select \u2018Options\u2019 in the left hand menu. How to activate the Excel Add-in The InstantAtlas Excel Data Manager add-in is automatically copied to your installation folder when you install InstantAtlas. However, you will need to enable it in order for the InstantAtlas menu and toolbar to appear. If you have followed the instructions in the InstantAtlas Getting Started guide, you will already … Continue reading The Excel Add-in<\/span><\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"parent":5071,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-5091","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=5091"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5091\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5071"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=5091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2021\/12\/Exceladdin6120.png\")
<\/a><\/p>\n<\/a><\/p>\nThe Buttons of the InstantAtlas Toolbar<\/h2>\n
\n
How to deactivate the Excel Add-in<\/h2>\n
\n2. Select \u2018Add-ins\u2019 from the left hand side menu.
\n3. Click ‘Go…’ at the bottom of this pane, to Manage Excel Add-ins
\n4. The add-ins dialog will open, click the checkbox for the Excel Data Manager so that it is unselected.
\n5. Click \u2018OK\u2019 to close the dialog. You will see that the \u2018InstantAtlas\u2019 menu and toolbar have disappeared.<\/p>\n","protected":false},"excerpt":{"rendered":"