FXLData Wizard - Revision history

Vmurrell: /* Overview */

2026-06-29T15:29:09Z

‎Overview

Vmurrell: /* FXL Data Version Version 1.3 onwards */

2026-06-29T15:26:28Z

‎FXL Data Version Version 1.3 onwards

Vmurrell: /* FXL Data Version Version 1.3 */

2026-06-29T13:24:07Z

‎FXL Data Version Version 1.3

Vmurrell: /* Overview */

2026-06-29T12:25:01Z

‎Overview

Vmurrell at 14:41, 15 June 2026

2026-06-15T14:41:38Z

Vmurrell: /* Ribbon Bar */

2026-06-15T14:39:56Z

‎Ribbon Bar

Vmurrell: /* Ribbon Bar */

2026-06-15T14:33:44Z

‎Ribbon Bar

Vmurrell: /* Ribbon Bar */

2026-06-15T14:28:45Z

‎Ribbon Bar

Vmurrell: /* FXL Data Version Version 1.3 */

2025-08-13T12:13:01Z

‎FXL Data Version Version 1.3

Vmurrell: /* Ribbon Bar */

2025-08-11T10:39:04Z

‎Ribbon Bar

@@ Line 12: / Line 12: @@
 * Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function.
 * Modify an existing =FXLData() or = FXLDataV() function by selecting the worksheet cell before launching the Wizard.
 =Wizard=

@@ Line 16: / Line 16: @@
 ==FXL Data Version Version 1.3 onwards==
 [[File:Wizard-r1-3.png|1200px]]
 ===Rest Argument Builder ===

@@ Line 14: / Line 14: @@
 =Wizard=
-==FXL Data Version Version 1.3==
+==FXL Data Version Version 1.3 onwards==
 [[File:Wizard-r1-3.png|1200px]]

@@ Line 3: / Line 3: @@
 An Excel ribbon bar tool for interactively building and editing [[FXLData]] functions.
 =Overview=
-The FXLData Wizard is part of the [[FXLData]] add-in for Excel which provides a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet.
+The FXLData Wizard is part of the add-in for Excel which provides a collection of functions for retrieving statistical data from a Fusion Registry directly into a worksheet.
 The Wizard helps in the task of building and modifying =FXLData() and =FXLDataV() functions which take a number of parameters including the Fusion Registry to connect to, the Dataflow and a data query expression - typically an SDMX [[Series Key|series key]].

@@ Line 12: / Line 12: @@
 * Select a blank cell in the worksheet and launch the Wizard to create a new FXLData function.
 * Modify an existing =FXLData() or = FXLDataV() function by selecting the worksheet cell before launching the Wizard.
 =Wizard=

← Older revision		Revision as of 14:39, 15 June 2026
Line 37:		Line 37:

	'''''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''''' 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","")

	=Wizard=		=Wizard=

← Older revision		Revision as of 14:33, 15 June 2026
Line 14:		Line 14:

	=Ribbon Bar=		=Ribbon Bar=
−	~~[[File:Wizard-button.png]] Launch the function helper 'Wizard'~~

−	~~[[File:Login-button.png]] Launch the Login Function so sign into FXLData~~
−
−	~~[[File:Refresh-button.png]] Refresh the FXLData function~~
−
−	~~[[File:Purge-button.png]] Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source~~
−
−	~~[[File:Diag-button.png]] Diagnostics - xxxxxxxxxxxxx~~
−
−	~~[[File:Logs-button.png]] View Logs - xxxxxxxxxxxxx~~
−
−	~~[[File:Sys-info.png]] System Info - xxxxxxxxxxxxx~~


		+	{\| class="wikitable"
		+	\|-
		+	! Option !! Usage
		+	\|-
		+	\| [[File:Wizard-button.png]] \|\| Launch the function helper 'Wizard'
		+	\|-
		+	\| [[File:Login-button.png]] \|\|Launch the Login Function so sign into FXLData
		+	\|-
		+	\| [[File:Refresh-button.png]] \|\| Refresh the FXLData function
		+	\|-
		+	\| [[File:Purge-button.png]] \|\| Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source
		+	\|-
		+	\| [[File:Diag-button.png]] \|\| Diagnostics - xxxxxxxxxxxxx
		+	\|-
		+	\| [[File:Logs-button.png]] \|\| View Logs - xxxxxxxxxxxxx
		+	\|-
		+	\| [[File:Sys-info.png]] \|\| System Info - xxxxxxxxxxxxx
		+	\|}

	'''''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''''' 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

@@ Line 14: / Line 14: @@
 =Ribbon Bar=
-[[File:Wizard icon.JPG]] Launch the function helper 'Wizard'
+[[File:Wizard-button.png]] Launch the function helper 'Wizard'
 '''''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

@@ Line 20: / Line 20: @@
 [[File:Purge icon.JPG]] Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source
-'''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''''' 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
 =Wizard=