Difference between revisions of "FusionXL install"

From FMR Knowledge Base
Jump to navigation Jump to search
Line 15: Line 15:
  
 
====Using XLSSTART folder====
 
====Using XLSSTART folder====
Place the XLAM file in the Excel sub directory folder '''XLSTART''' as shown in the example path below:
+
Copy the XLAM file to the Excel sub directory folder '''XLSTART''' as shown in the example path below:
  
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART
  
====Using the Addins sub directory folder====
+
Files in this folder are automatically loaded when Excel starts.
Place the XLAM file in the Excel sub directory folder '''XLSTART''' as shown in the example path below:
+
 
 +
====Using Excel's add-in maintenance facility====
 +
Copy the XLAM file to the Microsoft '''AddIns''' folder:
  
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns
 
  C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns
  
Having done this, the next step is to enable the Add-in. In Excel select the Options menu and then Add-ins.
+
Register the add-in with Excel by selecting the Options menu, then choosing Add-Ins.
 
 
  
[[File:FXL2.png|800px]]
+
[[File:FXL2.png|600px]]
  
 
After clicking '''Go''' an Add-Ins window will be displayed which will show '''FusionXL''' as an available add-in.  Select this add-in and click '''OK'''.
 
After clicking '''Go''' an Add-Ins window will be displayed which will show '''FusionXL''' as an available add-in.  Select this add-in and click '''OK'''.

Revision as of 09:08, 26 August 2022

Overview

FusionXL is an Excel add in for Fusion Metadata Registry providing three main functions:

  • Browse and view structures
  • Create and maintain structures - in particular useful for maintaining large codelists
  • Author, validate and convert datasets

FXL1.PNG

Download

The FusionXL add in is a single Excel XLAM file which can be downloaded from here: FusionXL

To add FXL to Windows 10 or higher, follow one of the two steps below.

Install

Using XLSSTART folder

Copy the XLAM file to the Excel sub directory folder XLSTART as shown in the example path below:

C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART

Files in this folder are automatically loaded when Excel starts.

Using Excel's add-in maintenance facility

Copy the XLAM file to the Microsoft AddIns folder:

C:\Users\[your user name]\AppData\Roaming\Microsoft\AddIns

Register the add-in with Excel by selecting the Options menu, then choosing Add-Ins.

FXL2.png

After clicking Go an Add-Ins window will be displayed which will show FusionXL as an available add-in. Select this add-in and click OK.


FXL3.png

After clicking OK, restart Excel to see the RXL tab as shown in the image above.

You are now ready to connect FXL to a Registry.