User guide

Page 96

visualise | communicate | ENGAGE The InstantAtlas Excel Data Manager

g the InstantAtlas Area Profile Template User Guide

The add-ins tab should now display two new buttons (Figure 117). There

is also a menu item called Instant Atlas from which these functions can

also be selected.

Figure 117

Older versions of Excel

Open Excel. If no blank workbook automatically opens then open a new

workbook. Click ‘Tools’, ‘Add-Ins’ and the ‘Add-Ins’ dialog will open

(Figure 118).

Figure 118

Select the InstantAtlas Data Manager from the list so that the checkbox

becomes checked. Click ‘OK’. The dialog will close and you will see that

Excel has a new menu called ‘InstantAtlas’ (Figure 119) and a new toolbar

with two buttons (Figure 120).

Figure 119

Figure 120

The add-in should be automatically installed. If however you cannot find

the add-in in the list click the ‘Browse’ button and browse to the add-in

provided with your InstantAtlas software. This is an XLA file called ‘IA Data

Manager {version number}.xla’ located in the ‘InstantAtlas’ folder created

during installation of your InstantAtlas software. Click ‘OK’. The

InstantAtlas Data Manager will appear among your list of add-ins. If you

are prompted to copy the add-in file to your ‘Add-Ins’ folder we recommend

that you say ‘Yes’.

You can click and drag the toolbar to a dock in a new location above the

worksheet. Alternatively you can drag it over the worksheet to display it as

a floating toolbar. The menu and toolbar will be visible each time you start

Excel.

This section of the user guide documents the ‘IA Export’ button. The ‘IA

Merge Files’ button is used to create data files for multiple geography