FXLData Ribbon Bar

The FXLData has a ribbon bar which offers the following functions.

Option	Usage
	Launch the function helper 'Wizard'. Click here to learn more about the Wizard.
	Launch the Login Function so sign into FXLData. Click here to learn more about the Login options.
	Refresh the FXLData function. Click here to lean more about this option.
	Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here to learn more about this option.
	Diagnostics. Click here to learn more about this feature.
	View Logs. Click here to learn more about this feature.
	System Info. Click here to learn more about this feature.

Retired in R1.3 Automatic Calculation control whether changes to FXLData formulas automatically refresh the dataset in Legacy Mode - uncheck to speed up bulk changes to worksheets such as deleting large numbers of cells

Retired in R1.3.03 Legacy Mode The need for Legacy mode has been superseded by the removal of the Automatic Calculation facility. The Refresh button now works as expected and will perform an update on request.

As part of the change you will notice that the ampersand is inserted into the query shown in the formula bar.

Example:

@FXLData("https://demo.metadatatechnology.com/FusionRegistry","WB,WDI_POVERTY,1.0",".SI_DST_02ND_20+SI_DST_03RD_20+SI_DST_04TH_20.",100,,,,"id","TRUE","FALSE","TRUE","FALSE","")