When exporting data from the Dashboard to the Excel Add-in the formula returns a #VALUE error.

Exporting prices from the Dashboard is a 2-step process – the format of the data copied from the Dashboard is controlled by the regional/language settings in the browser. These need to be aligned to the below Region settings of your pc or laptop in order for the format of the data to work.

Depending on your browser settings the Excel Add-in formulae may export with a semi colon “;” or comma “,” as a list separator. You can check this by selecting “Copy for Excel Add-in” in the Dashboard widget and pasting directly into Word or Notepad:

To ensure Excel is aligned with either of the above, you can check your pc/laptop Clock & Region settings. From your start menu open Control Panel > Clock and Region > Change date, time or number formats > Additional settings (as per screenshots below):

If your browser regional settings export with semi-colon’s, set the List separator to semi-colons so your Excel formulae will look like this:

If your browser regional settings export with commas set the List separator to commas so your Excel formulae will look like this: