Fusion Registry Wiki - User contributions [en]

FXL Data changes in Hotfix February 2025

2026-06-15T15:35:57Z

Vmurrell: /* Diagnostic Tool */

[[Category:How to and other features in FXLData]]
== Background ==
In February 2025, a new version of FXLData was made available via an “on request” Hotfix.

This new version addresses several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365.

When this version is incorporated into the next full release of the Fusion Regnology product suite, the wiki will be updated accordingly but, in the meantime, this is a summary of the key changes.

=== Appearance ===
On opening Excel and enabling the latest version of the FX Data add-in, you will notice two significant changes.

[[File:Appearance.png|800px]]

=== [[Legacy Mode - FXLData |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","")

=== Refresh ===
This article can now be found [[FXLData_Refresh|here]]

=== Diagnostic Tool ===

This article can now be found [[FXLData_Diagnostics|here]]

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

==== FXL DataRefreshable Worksheet ====
The basic functionality as decsribed [[FXLData Refreshable Worksheet|here]] remains unchanged however please note that to retrieve the actual data, use the Refresh button to update.

==== Change Log ====
The function =FXLDataVersion("changelog") displays the change log which is now displayed in reverse chronological order.

FXLData Diagnostics

2026-06-15T15:35:03Z

Vmurrell:

[[Category:How to and other features in FXLData]]
=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

FXL Data changes in Hotfix February 2025

2026-06-15T15:33:54Z

Vmurrell: /* Refresh */

[[Category:How to and other features in FXLData]]
== Background ==
In February 2025, a new version of FXLData was made available via an “on request” Hotfix.

This new version addresses several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365.

When this version is incorporated into the next full release of the Fusion Regnology product suite, the wiki will be updated accordingly but, in the meantime, this is a summary of the key changes.

=== Appearance ===
On opening Excel and enabling the latest version of the FX Data add-in, you will notice two significant changes.

[[File:Appearance.png|800px]]

=== [[Legacy Mode - FXLData |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","")

=== Refresh ===
This article can now be found [[FXLData_Refresh|here]]

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

==== FXL DataRefreshable Worksheet ====
The basic functionality as decsribed [[FXLData Refreshable Worksheet|here]] remains unchanged however please note that to retrieve the actual data, use the Refresh button to update.

==== Change Log ====
The function =FXLDataVersion("changelog") displays the change log which is now displayed in reverse chronological order.

FXLData what's new in R1.3.03

2026-06-15T15:29:54Z

Vmurrell: /* Rest Arguments */

Rest Arguments Builder

2026-06-15T15:29:07Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

FXLData what's new in R1.3.03

2026-06-15T15:27:24Z

Vmurrell: /* Refresh */

FXLData what's new in R1.3.03

2026-06-15T15:26:33Z

Vmurrell: /* Refresh */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
This article can now be found [[FXLData_Refresh|here]]

=== Diagnostic Tool ===
This article can now be found [[FXLData_Diagnostics| here]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== New Functions introduced =====

These options are available but are currently in beta test.

[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===

Thhis article can now be found [[FXLData_Refresh|here]]

FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData what's new in R1.3.03

2026-06-15T15:25:28Z

Vmurrell: /* Diagnostic Tool */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

=== Diagnostic Tool ===
This article can now be found [[FXLData_Diagnostics| here]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== New Functions introduced =====

These options are available but are currently in beta test.

[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===

Thhis article can now be found [[FXLData_Refresh|here]]

FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData Diagnostics

2026-06-15T15:23:30Z

Vmurrell:

[[Category:How to and other features in FXLData]]

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

FXLData what's new in R1.3.03

2026-06-15T15:22:29Z

Vmurrell: /* Refresh */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== New Functions introduced =====

These options are available but are currently in beta test.

[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===

Thhis article can now be found [[FXLData_Refresh|here]]

FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData what's new in R1.3.03

2026-06-15T15:21:57Z

Vmurrell: /* Legacy Mode */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== New Functions introduced =====

These options are available but are currently in beta test.

[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData Refresh

2026-06-15T15:21:20Z

Vmurrell:

[[Category:How to and other features in FXLData]]

''Broken links, more work needed.''

FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData what's new in R1.3.03

2026-06-15T15:19:40Z

Vmurrell: /* System Properties */

[[Category:How to and other features in FXLData]]
Since the last main release of FXL Data in July 2024, a number of changes and enhancements have been introduced. The changes address several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365 and incorporating a number of great new features.

Some of these changes were made available via an optional Hot fixes but the Release of R1.3 brings all the changes together and includes a useful new feature as well as various bug fixes.

A summary of all the changes can be viewed in the Change Log [[FXLData_Change_Log | Change Log]] which shows which changes were made in which Hotfix and which are new in R1.3. This page summarises all the main changes as at Version 1.3.

Remember - to use these changes the FXLData add-in must be installed, follow the installation instructions found [[Downlad_and_Installation_FXLData |here.]]

== FXLData Tab ==
On opening Excel and enabling the latest version of the FX Data add-in, you will see several significant changes on the FXLData Tab within Excel.

[[File:Appearance.png|800px]]

=== [[Legacy Mode - FXLData |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","")

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as described here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

== FXLData Wizard ==

===Dataflow Selection===

A new selection box has been added to make it easier to select a dataflow.

[[File:Dataflow selection.png|1000px]]

===Selecting Items===
[[File:Codelist display.png|1000px]]

===Rest Arguments===

The Wizard (available from the FXL Data tab) now includes a button to select the Rest Arguments Builder. Which can be used to specify additional SDMX query arguments that are not available through other options in the User Interface, such as round=2 for rounding numeric values. It is intended for the advanced user who needs finer control over the query behaviour.

[[File:Rest-argument-builder-button.png|1000-px]]

To use the Builder, select a dataflow and then click on the Builder button.

Click the button to access the builder.

[[File:Rest-argument-builder.png|1200-px]]

'''Apply Button'''

When the Apply button is pressed in the REST Arguments Builder, it performs the following action:

* It populates the REST Args box on the main Wizard screen with the constructed query string based on the enabled and valid arguments.
* It does not execute the FXLData function or retrieve any data at this stage.
* To actually run the query and fetch data into Excel, the user must return to the Wizard screen and press its Apply button.
This separation ensures the user can review and finalize their full query setup before triggering data retrieval.

====Interaction with the Wizard====
'''Existing Arguments'''

If the wizard already contains rest arguments when the Builder is opened, it will attempt to interpret and reconstruct the existing argument as accurately as possible.

[[File:Rest-arguments-box.png|1200-px]]

'''Arguments handled via the Wizard'''

* startperiod
* endperiod
* max
* time-format-frequency-id

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

===== New Functions introduced =====

These options are available but are currently in beta test.

[[FXLDataLookup_and_FXLDataPeriod_Functions |You can read more in this article.]]

===== System Properties =====
This article can now be found [[FXLData_System_Info|here]]

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

FXLData System Info

2026-06-15T15:17:57Z

Vmurrell:

[[Category:How to and other features in FXLData]]

A new option is available on the FXL Data tab which, when selected, will display information as shown in the example aside.

[[File:Click-sys-info-ER.png|thumb]]

Rest Arguments Builder

2026-06-15T15:15:25Z

Vmurrell:

[[Category:How to and other features in FXLData]]

More content coming soon.

[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments |Please click here to read the article.]]

FXL Data changes in Hotfix February 2025

2026-06-15T15:11:49Z

Vmurrell:

[[Category:How to and other features in FXLData]]
== Background ==
In February 2025, a new version of FXLData was made available via an “on request” Hotfix.

This new version addresses several issues identified by users including, to stablise the product, removing the difference between using the Legacy Mode features (these catered for users who used Microsoft Excel 2010-2019) and those using subsequent versions i.e., MS Office 365.

When this version is incorporated into the next full release of the Fusion Regnology product suite, the wiki will be updated accordingly but, in the meantime, this is a summary of the key changes.

=== Appearance ===
On opening Excel and enabling the latest version of the FX Data add-in, you will notice two significant changes.

[[File:Appearance.png|800px]]

=== [[Legacy Mode - FXLData |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","")

=== Refresh ===
FXLData no longer uses the normal Excel calculations in Microsoft 365. As a result, if a change is made as describe here [[Refresh - FXLData#Refresh| Refresh article]] a manual refresh is necessary.

The Refresh option is no longer restricted to older versions of Excel, the options available are detailed [[Refresh - FXLData#Office 2010-2019 Excel and Microsoft 365 Excel working in legacy Mode|here.]]

Note that if the formula itself is deleted, you will also need to delete any returned data.

=== Diagnostic Tool ===
This feature has been introduced to help Regnology diagnose any issues encountered when using FXL Data. By default, the feature is switched off. When required, two options are available which supply different levels of detail. When the tool is enabled a log file will be created.

[[File:Diagnostic tool.png|1000px]]

=== Other point to note ===
==== Functions ====
The TimeFormatFrequencyID parameter is now available when using the Functions:
* FXLDataURL
* FXLDataURLV
* FXLDataURLFact

[[File:TimeFormatFrequencyID.png|500px]]

==== FXL DataRefreshable Worksheet ====
The basic functionality as decsribed [[FXLData Refreshable Worksheet|here]] remains unchanged however please note that to retrieve the actual data, use the Refresh button to update.

==== Change Log ====
The function =FXLDataVersion("changelog") displays the change log which is now displayed in reverse chronological order.

FXLData Ribbon Bar

2026-06-15T14:59:45Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
|-
| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[FXLData_Refresh| to lean more about this option.]]
|-
| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[FXLData_Purge|to learn more about this option.]]
|-
| [[File:Diag-button.png]] || Diagnostics. Click here [[FXLData_Diagnostics| to learn more about this feature.]]
|-
| [[File:Logs-button.png]] || View Logs. Click here [[FXLData_Logs| to learn more about this feature.]]
|-
| [[File:Sys-info.png]] || System Info. Click here [[FXLData_System_Info|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","")

FXLData Refresh

2026-06-15T14:58:27Z

Vmurrell: Vmurrell moved page Refresh FXLData to FXLData Refresh without leaving a redirect

[[Category:How to and other features in FXLData]]

coming soon

FXLData Ribbon Bar

2026-06-15T14:57:52Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
|-
| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[Refresh_FXLData| to lean more about this option.]]
|-
| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[FXLData_Purge|to learn more about this option.]]
|-
| [[File:Diag-button.png]] || Diagnostics. Click here [[FXLData_Diagnostics| to learn more about this feature.]]
|-
| [[File:Logs-button.png]] || View Logs. Click here [[FXLData_Logs| to learn more about this feature.]]
|-
| [[File:Sys-info.png]] || System Info. Click here [[FXLData_System_Info|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","")

FXLData Purge

2026-06-15T14:57:05Z

Vmurrell: Vmurrell moved page FXL Data Purge to FXLData Purge

[[Category:How to and other features in FXLData]]

Coming soon.

FXL Data Purge

2026-06-15T14:57:05Z

Vmurrell: Vmurrell moved page FXL Data Purge to FXLData Purge

#REDIRECT [[FXLData Purge]]

FXLData Ribbon Bar

2026-06-15T14:56:22Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
|-
| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[Refresh_FXLData| to lean more about this option.]]
|-
| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[/FXL_Data_Purge|to learn more about this option.]]
|-
| [[File:Diag-button.png]] || Diagnostics. Click here [[FXLData_Diagnostics| to learn more about this feature.]]
|-
| [[File:Logs-button.png]] || View Logs. Click here [[FXLData_Logs| to learn more about this feature.]]
|-
| [[File:Sys-info.png]] || System Info. Click here [[FXLData_System_Info|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","")

FXLData System Info

2026-06-15T14:55:33Z

Vmurrell: Created page with "Category:How to and other features in FXLData Coming soon."

[[Category:How to and other features in FXLData]]

Coming soon.

FXLData Logs

2026-06-15T14:54:10Z

Vmurrell: Created page with "Category:How to and other features in FXLData Coming soon."

[[Category:How to and other features in FXLData]]

Coming soon.

FXLData Diagnostics

2026-06-15T14:51:50Z

Vmurrell: Created page with "Category:How to and other features in FXLData Coming soon"

[[Category:How to and other features in FXLData]]

Coming soon

/FXL Data Purge

2026-06-15T14:50:41Z

Vmurrell: Created page with "coming soon"

coming soon

FXLData Ribbon Bar

2026-06-15T14:49:55Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
|-
| [[File:Refresh-button.png]] || Refresh the FXLData function. Click here [[Refresh_FXLData| to lean more about this option.]]
|-
| [[File:Purge-button.png]] || Purge the local data cache - use this to refresh the result sets from the Fusion Registry data source. Click here [[/FXL_Data_Purge|to learn more about this option.]]
|-
| [[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.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","")

FXLData Purge

2026-06-15T14:48:17Z

Vmurrell: Created page with "Category:How to and other features in FXLData Coming soon."

[[Category:How to and other features in FXLData]]

Coming soon.

FXLData Refresh

2026-06-15T14:46:11Z

Vmurrell: Removed redirect to Refresh - FXLData

[[Category:How to and other features in FXLData]]

coming soon

FXLData Refresh

2026-06-15T14:45:24Z

Vmurrell: Vmurrell moved page Refresh - FXLData - Draft to Refresh FXLData

#REDIRECT [[Refresh - FXLData]]

Refresh - FXLData - Draft

2026-06-15T14:45:24Z

Vmurrell: Vmurrell moved page Refresh - FXLData - Draft to Refresh FXLData

#REDIRECT [[Refresh FXLData]]

FXLData Ribbon Bar

2026-06-15T14:44:26Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the Wizard.]]
|-
| [[File:Login-button.png]] ||Launch the Login Function so sign into FXLData. Click here [[Security_and_Authentication_in_FXLData#Extended_Authentication_Capabilities| to learn more about the Login options.]]
|-
| [[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.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","")

FXLData Ribbon Bar

2026-06-15T14:42:23Z

Vmurrell:

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| class="wikitable"
|-
! Option !! Usage
|-
| [[File:Wizard-button.png]] || Launch the function helper 'Wizard'. Click here [[FXLData_Wizard| to learn more about the 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.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","")

FXLData Wizard

2026-06-15T14:41:38Z

Vmurrell:

[[Category:How to and other features in FXLData]]
__NOTOC__
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 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]].

[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon]]

[[FXLData#Quick_Start|Installing]] the FXLData Excel add-in adds a FXLData menu option and the ƒ''x'' button to the ribbon to launch the Wizard.
* 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=
==FXL Data Version Version 1.3==
[[File:Wizard-r1-3.png|1200px]]

===Rest Argument Builder ===
[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments | Click here to learn more about the new Rest Arguments Builder.]]

==FXL Data Version Version 1.0==
[[File:Wizard.png|1200px]]

=Guidance=
* All parameters can take either a literal value (e.g. a number or a text string), a cell reference (e.g. A4) or an Excel formula (e.g. sum(A4,A6))
* A parameter's result value is shown to the right which is just the literal, the contents of the referenced cell, or the result of the Excel formula
* Red indicates the value is not valid
* Use the '''Apply''' button to apply changes made in the Wizard to the worksheet
* The FXLData function is refreshed automatically everytime the Apply button is clicked
* The '''Registry URL''' is the base URL of the Fusion Registry data source - the same URL used to access the web user interface
* Use the '''+''' and '''-''' buttons to add and remove favourite Fusion Registries from the drop down list - the '''Def''' button sets the default
* The '''Dataflow''' can be either just the source Dataflow's ID (e.g. EXR) provided that is unique, or the fully-qualified Dataflow identifier (e.g. ECB,EXR,1.0)
* The Dataflow drop down provides an up to date list of all dataflows from the selected Fusion Registry that contain data
* The '''Data Expression''' defines precisely what series to retrieve using an SDMX Series Key or JSON packet describing a series basket that can be generated using Fusion Data Browser
* Use the keyword '''all''' for the Data Expression to retrieve all series for the selected Dataflow
* The '''Start Period''' and '''End Period''' select only observations between those dates which must be in [[SDMX Time Formats|SDMX time format]] - both are optional
* '''REST Args''' allows additional data [[Data Query Web Service|REST query arguments]] to be set such as rounding, calculated measures, dimension at observation and aggregations
* The REST Args expression must follow the standard syntax for URL parameters using '&' as a separator , e.g. ''round=2&attributes=UNIT''
* Favourite Rest Arg expressions can be saved and deleted using the '''+''' and '''-''' buttons - the '''?''' button provides help on the available arguments and their usage
* Daily Time Format check box - (introduced in July 2024) - '''Daily Time Format''' or YYYY-MM-DD both an Excel friendly and [[SDMX_Time_Formats |SDMX compatible format]]. For instance if Daily Time Format is checked and an underlying date is 2024 then 2024-12-31 will be rendered to Excel.

FXLData Ribbon Bar

2026-06-15T14:40:49Z

Vmurrell: Created page with " Category:How to and other features in FXLData The FXLData has a ribbon bar which offers the following functions. {| class="wikitable" |- ! Option !! Usage |- | File:Wi..."

[[Category:How to and other features in FXLData]]
The FXLData has a ribbon bar which offers the following functions.

{| 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.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","")

FXLData Wizard

2026-06-15T14:39:56Z

Vmurrell: /* Ribbon Bar */

[[Category:How to and other features in FXLData]]
__NOTOC__
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 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]].

[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon]]

[[FXLData#Quick_Start|Installing]] the FXLData Excel add-in adds a FXLData menu option and the ƒ''x'' button to the ribbon to launch the Wizard.
* 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.

=Ribbon Bar=

{| 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.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=
==FXL Data Version Version 1.3==
[[File:Wizard-r1-3.png|1200px]]

===Rest Argument Builder ===
[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments | Click here to learn more about the new Rest Arguments Builder.]]

==FXL Data Version Version 1.0==
[[File:Wizard.png|1200px]]

=Guidance=
* All parameters can take either a literal value (e.g. a number or a text string), a cell reference (e.g. A4) or an Excel formula (e.g. sum(A4,A6))
* A parameter's result value is shown to the right which is just the literal, the contents of the referenced cell, or the result of the Excel formula
* Red indicates the value is not valid
* Use the '''Apply''' button to apply changes made in the Wizard to the worksheet
* The FXLData function is refreshed automatically everytime the Apply button is clicked
* The '''Registry URL''' is the base URL of the Fusion Registry data source - the same URL used to access the web user interface
* Use the '''+''' and '''-''' buttons to add and remove favourite Fusion Registries from the drop down list - the '''Def''' button sets the default
* The '''Dataflow''' can be either just the source Dataflow's ID (e.g. EXR) provided that is unique, or the fully-qualified Dataflow identifier (e.g. ECB,EXR,1.0)
* The Dataflow drop down provides an up to date list of all dataflows from the selected Fusion Registry that contain data
* The '''Data Expression''' defines precisely what series to retrieve using an SDMX Series Key or JSON packet describing a series basket that can be generated using Fusion Data Browser
* Use the keyword '''all''' for the Data Expression to retrieve all series for the selected Dataflow
* The '''Start Period''' and '''End Period''' select only observations between those dates which must be in [[SDMX Time Formats|SDMX time format]] - both are optional
* '''REST Args''' allows additional data [[Data Query Web Service|REST query arguments]] to be set such as rounding, calculated measures, dimension at observation and aggregations
* The REST Args expression must follow the standard syntax for URL parameters using '&' as a separator , e.g. ''round=2&attributes=UNIT''
* Favourite Rest Arg expressions can be saved and deleted using the '''+''' and '''-''' buttons - the '''?''' button provides help on the available arguments and their usage
* Daily Time Format check box - (introduced in July 2024) - '''Daily Time Format''' or YYYY-MM-DD both an Excel friendly and [[SDMX_Time_Formats |SDMX compatible format]]. For instance if Daily Time Format is checked and an underlying date is 2024 then 2024-12-31 will be rendered to Excel.

FXLData Wizard

2026-06-15T14:33:44Z

Vmurrell: /* Ribbon Bar */

[[Category:How to and other features in FXLData]]
__NOTOC__
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 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]].

[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon]]

[[FXLData#Quick_Start|Installing]] the FXLData Excel add-in adds a FXLData menu option and the ƒ''x'' button to the ribbon to launch the Wizard.
* 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.

=Ribbon Bar=

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

=Wizard=
==FXL Data Version Version 1.3==
[[File:Wizard-r1-3.png|1200px]]

===Rest Argument Builder ===
[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments | Click here to learn more about the new Rest Arguments Builder.]]

==FXL Data Version Version 1.0==
[[File:Wizard.png|1200px]]

=Guidance=
* All parameters can take either a literal value (e.g. a number or a text string), a cell reference (e.g. A4) or an Excel formula (e.g. sum(A4,A6))
* A parameter's result value is shown to the right which is just the literal, the contents of the referenced cell, or the result of the Excel formula
* Red indicates the value is not valid
* Use the '''Apply''' button to apply changes made in the Wizard to the worksheet
* The FXLData function is refreshed automatically everytime the Apply button is clicked
* The '''Registry URL''' is the base URL of the Fusion Registry data source - the same URL used to access the web user interface
* Use the '''+''' and '''-''' buttons to add and remove favourite Fusion Registries from the drop down list - the '''Def''' button sets the default
* The '''Dataflow''' can be either just the source Dataflow's ID (e.g. EXR) provided that is unique, or the fully-qualified Dataflow identifier (e.g. ECB,EXR,1.0)
* The Dataflow drop down provides an up to date list of all dataflows from the selected Fusion Registry that contain data
* The '''Data Expression''' defines precisely what series to retrieve using an SDMX Series Key or JSON packet describing a series basket that can be generated using Fusion Data Browser
* Use the keyword '''all''' for the Data Expression to retrieve all series for the selected Dataflow
* The '''Start Period''' and '''End Period''' select only observations between those dates which must be in [[SDMX Time Formats|SDMX time format]] - both are optional
* '''REST Args''' allows additional data [[Data Query Web Service|REST query arguments]] to be set such as rounding, calculated measures, dimension at observation and aggregations
* The REST Args expression must follow the standard syntax for URL parameters using '&' as a separator , e.g. ''round=2&attributes=UNIT''
* Favourite Rest Arg expressions can be saved and deleted using the '''+''' and '''-''' buttons - the '''?''' button provides help on the available arguments and their usage
* Daily Time Format check box - (introduced in July 2024) - '''Daily Time Format''' or YYYY-MM-DD both an Excel friendly and [[SDMX_Time_Formats |SDMX compatible format]]. For instance if Daily Time Format is checked and an underlying date is 2024 then 2024-12-31 will be rendered to Excel.

FXLData Wizard

2026-06-15T14:28:45Z

Vmurrell: /* Ribbon Bar */

[[Category:How to and other features in FXLData]]
__NOTOC__
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 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]].

[[File:FXLData Wizard Ribbon 058.JPG|FXLData Excel ribbon]]

[[FXLData#Quick_Start|Installing]] the FXLData Excel add-in adds a FXLData menu option and the ƒ''x'' button to the ribbon to launch the Wizard.
* 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.

=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

'''''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=
==FXL Data Version Version 1.3==
[[File:Wizard-r1-3.png|1200px]]

===Rest Argument Builder ===
[[FXLData_what%27s_new_in_R1.3%3F#Rest_Arguments | Click here to learn more about the new Rest Arguments Builder.]]

==FXL Data Version Version 1.0==
[[File:Wizard.png|1200px]]

=Guidance=
* All parameters can take either a literal value (e.g. a number or a text string), a cell reference (e.g. A4) or an Excel formula (e.g. sum(A4,A6))
* A parameter's result value is shown to the right which is just the literal, the contents of the referenced cell, or the result of the Excel formula
* Red indicates the value is not valid
* Use the '''Apply''' button to apply changes made in the Wizard to the worksheet
* The FXLData function is refreshed automatically everytime the Apply button is clicked
* The '''Registry URL''' is the base URL of the Fusion Registry data source - the same URL used to access the web user interface
* Use the '''+''' and '''-''' buttons to add and remove favourite Fusion Registries from the drop down list - the '''Def''' button sets the default
* The '''Dataflow''' can be either just the source Dataflow's ID (e.g. EXR) provided that is unique, or the fully-qualified Dataflow identifier (e.g. ECB,EXR,1.0)
* The Dataflow drop down provides an up to date list of all dataflows from the selected Fusion Registry that contain data
* The '''Data Expression''' defines precisely what series to retrieve using an SDMX Series Key or JSON packet describing a series basket that can be generated using Fusion Data Browser
* Use the keyword '''all''' for the Data Expression to retrieve all series for the selected Dataflow
* The '''Start Period''' and '''End Period''' select only observations between those dates which must be in [[SDMX Time Formats|SDMX time format]] - both are optional
* '''REST Args''' allows additional data [[Data Query Web Service|REST query arguments]] to be set such as rounding, calculated measures, dimension at observation and aggregations
* The REST Args expression must follow the standard syntax for URL parameters using '&' as a separator , e.g. ''round=2&attributes=UNIT''
* Favourite Rest Arg expressions can be saved and deleted using the '''+''' and '''-''' buttons - the '''?''' button provides help on the available arguments and their usage
* Daily Time Format check box - (introduced in July 2024) - '''Daily Time Format''' or YYYY-MM-DD both an Excel friendly and [[SDMX_Time_Formats |SDMX compatible format]]. For instance if Daily Time Format is checked and an underlying date is 2024 then 2024-12-31 will be rendered to Excel.

File:Sys-info.png

2026-06-15T14:28:32Z

Vmurrell:

File:Logs-button.png

2026-06-15T14:28:07Z

Vmurrell:

File:Diag-button.png

2026-06-15T14:27:38Z

Vmurrell:

File:Purge-button.png

2026-06-15T14:25:23Z

Vmurrell:

File:Refresh-button.png

2026-06-15T14:24:50Z

Vmurrell:

File:Login-button.png

2026-06-15T14:22:40Z

Vmurrell:

File:Wizard-button.png

2026-06-15T14:21:32Z

Vmurrell:

Release Plans

2026-06-15T14:08:44Z

Vmurrell:

__NOTOC__
Please refer to the Change Log(s) and Release Notes for more detail.

== R2.0.0.00_RFS_26.06.26 Estimated release date June 26, 2026 - Full Release ==

===Fusion Registry ===
* Upgrade from Spring 5 to Spring 7
* Support pop up box introduced [[Support_Tab| read more]]
* Database consistency checker web service [[Database_Consistency_Web_Service| read more]]
* Semantic and Non-Semantic structure versions - ability to co-exist
* Bulk Actions to include Hierarchy Associations
* Loading structures - ability to skip invalid structures [[Load_Structures#Submitting_Invalid_Structures| read more]]

===Fusion Data Browser ===
* Implementation of loading indicator

=== FXLData Enhancements ===
* Introduction of login functionality
* Introduction of System Properties reporter
* Support for hierarchical structures in the query builder
* Improved medium verbosity logging: limited to API request URLs and response codes
* Alignment of result grid data order with selected codes in the query builder

==P2.0.1.00_RFS_31.07.26 Estimated Release Date July 31, 2026 - Patch ==
Customer driven enhancements to Fusion Data Browser.

====Plus Miscellaneous bug fixes and minor enhancements, full details of which will be available in the Release Notes and Change Logs. ====

== H1.3.1.01_RFS_00.00.00 Release Date to follow ==
Contents - to follow.

Downlad and Installation FXLData

2026-06-15T14:06:03Z

Vmurrell: /* Installation */

[[Category:Getting Started FXLData]]
== Downloading FXL Data ==

To download the latest version of FXLData you need access to the Regnology Customer Portal. If you do not already have an account OR if you are having difficulty finding FXLData, please create a support ticket.

== Installation ==
The FXLData add-in is distributed as a single Excel file:

FXLData.xlam

The file should be copied into the Addins folder. This folder allows for plugins to be provided to a single location, but they can be separately enabled or disabled from within Microsoft Excel. Using the Addins folder requires two steps:

1. Copying the file into the Addins folder
2. Enabling the FXLData add-in from within Excel

First, you will need to locate your Addins folder. On Windows 11, this is located under your home folder in the following location:
C:\Users\[your user name]\AppData\Roaming\Microsoft\Addins

'''Note''': this folder may be in a different location on different versions of Windows and in non-standard installations. Please check with your system administrator if you cannot find this folder.

Copy the file FXLData.xlam file into this directory and then launch Excel. From within Excel, open the '''Developer''' tab, and select '''Excel Add-Ins'''. You will see a list of your available Addins, select FXLData and click OK. Please be aware that you may need to unlock the file first. To do this, open the Properties file and select and select "unlock" from the General Tab.

After clicking ‘OK’ the Add-Ins window will close and the ‘FXLData’ tab will be added to the Excel Ribbon. This tab will be available on all subsequent launches of Excel from this computer, unless the add-in is disabled from the add-ins menu (or the .xlam file is deleted from the file system).

Click on the FXLData tab to start using FXLData.

The resulting FXLData tab will be displayed in the Ribbon.

[[File:Ribbon-v2-2026.png|Wizard - 2026|1000px]]

'''Note''': ''this ribbon bar will be available from R.2.0 scheduled for June / July 2026''. If you are using an earlier version, you may not see all features.

Downlad and Installation FXLData

2026-06-15T14:05:30Z

Vmurrell: /* Installation */

[[Category:Getting Started FXLData]]
== Downloading FXL Data ==

To download the latest version of FXLData you need access to the Regnology Customer Portal. If you do not already have an account OR if you are having difficulty finding FXLData, please create a support ticket.

== Installation ==
The FXLData add-in is distributed as a single Excel file:

FXLData.xlam

The file should be copied into the Addins folder. This folder allows for plugins to be provided to a single location, but they can be separately enabled or disabled from within Microsoft Excel. Using the Addins folder requires two steps:

1. Copying the file into the Addins folder
2. Enabling the FXLData add-in from within Excel

First, you will need to locate your Addins folder. On Windows 11, this is located under your home folder in the following location:
C:\Users\[your user name]\AppData\Roaming\Microsoft\Addins

'''Note''': this folder may be in a different location on different versions of Windows and in non-standard installations. Please check with your system administrator if you cannot find this folder.

Copy the file FXLData.xlam file into this directory and then launch Excel. From within Excel, open the '''Developer''' tab, and select '''Excel Add-Ins'''. You will see a list of your available Addins, select FXLData and click OK. Please be aware that you may need to unlock the file first. To do this, open the Properties file and select and select "unlock" from the General Tab.

After clicking ‘OK’ the Add-Ins window will close and the ‘FXLData’ tab will be added to the Excel Ribbon. This tab will be available on all subsequent launches of Excel from this computer, unless the add-in is disabled from the add-ins menu (or the .xlam file is deleted from the file system).

Click on the FXLData tab to start using FXLData.

The resulting FXLData tab will be displayed in the Ribbon.

'''Note''': ''this ribbon bar will be available from R.2.0 scheduled for June / July 2026''. If you are using an earlier version, you may not see all features.

[[File:Ribbon-v2-2026.png|Wizard - 2026|1000px]]

Downlad and Installation FXLData

2026-06-15T14:04:46Z

Vmurrell: /* Installation */

[[Category:Getting Started FXLData]]
== Downloading FXL Data ==

To download the latest version of FXLData you need access to the Regnology Customer Portal. If you do not already have an account OR if you are having difficulty finding FXLData, please create a support ticket.

== Installation ==
The FXLData add-in is distributed as a single Excel file:

FXLData.xlam

The file should be copied into the Addins folder. This folder allows for plugins to be provided to a single location, but they can be separately enabled or disabled from within Microsoft Excel. Using the Addins folder requires two steps:

1. Copying the file into the Addins folder
2. Enabling the FXLData add-in from within Excel

First, you will need to locate your Addins folder. On Windows 11, this is located under your home folder in the following location:
C:\Users\[your user name]\AppData\Roaming\Microsoft\Addins

'''Note''': this folder may be in a different location on different versions of Windows and in non-standard installations. Please check with your system administrator if you cannot find this folder.

Copy the file FXLData.xlam file into this directory and then launch Excel. From within Excel, open the '''Developer''' tab, and select '''Excel Add-Ins'''. You will see a list of your available Addins, select FXLData and click OK. Please be aware that you may need to unlock the file first. To do this, open the Properties file and select and select "unlock" from the General Tab.

After clicking ‘OK’ the Add-Ins window will close and the ‘FusionXL’ tab will be added to the Excel Ribbon. This tab will be available on all subsequent launches of Excel from this computer, unless the add-in is disabled from the add-ins menu (or the .xlam file is deleted from the file system).

Click on the FXLData tab to start using FXLData.

The resulting FXLData tab will be displayed in the Ribbon.

'''Note''': ''this ribbon bar will be available from R.2.0 scheduled for June / July 2026''. If you are using an earlier version, you may not see all features.

[[File:Ribbon-v2-2026.png|Wizard - 2026|1000px]]

Downlad and Installation FXLData

2026-06-15T14:04:35Z

Vmurrell: /* Installation */

[[Category:Getting Started FXLData]]
== Downloading FXL Data ==

To download the latest version of FXLData you need access to the Regnology Customer Portal. If you do not already have an account OR if you are having difficulty finding FXLData, please create a support ticket.

== Installation ==
The FXLData add-in is distributed as a single Excel file:

FXLData.xlam

The file should be copied into the Addins folder. This folder allows for plugins to be provided to a single location, but they can be separately enabled or disabled from within Microsoft Excel. Using the Addins folder requires two steps:

1. Copying the file into the Addins folder
2. Enabling the FXLData add-in from within Excel

First, you will need to locate your Addins folder. On Windows 11, this is located under your home folder in the following location:
C:\Users\[your user name]\AppData\Roaming\Microsoft\Addins

'''Note''': this folder may be in a different location on different versions of Windows and in non-standard installations. Please check with your system administrator if you cannot find this folder.

Copy the file FXLData.xlam file into this directory and then launch Excel. From within Excel, open the '''Developer''' tab, and select '''Excel Add-Ins'''. You will see a list of your available Addins, select FXLData and click OK. Please be aware that you may need to unlock the file first. To do this, open the Properties file and select and select "unlock" from the General Tab.

After clicking ‘OK’ the Add-Ins window will close and the ‘FusionXL’ tab will be added to the Excel Ribbon. This tab will be available on all subsequent launches of Excel from this computer, unless the add-in is disabled from the add-ins menu (or the .xlam file is deleted from the file system).

Click on the FXLData tab to start using FXLData.

The resulting FXLData tab will be displayed in the Ribbon.

'''Note''': ''this ribbon bar will be available from R.2.0 scheduled for June / July 2026''. If you are using an earlier version, you may not see all features.

[[File:Ribbon-v2-2026.png|Wizard - 2026|1000px]]