/ Help centre
← All articles
End Users › General

When I export a query to excel to a sheet number that is not the currently displayed I receive a Subscript out of range error.

Applicable Versions: All In some circumstances when exporting data from the DataPA Excel Add-in to an Excel worksheet that is not the currently selected sheet a Subscript out of range error can occur. The error can be caused if the Excel EuroTool Addin (Eurotool.xla or Eurotool.xlam) is active…

Updated 23 March 2018

 Applicable Versions: All


In some circumstances when exporting data from the DataPA Excel Add-in to an Excel worksheet that is not the currently selected sheet a Subscript out of range error can occur.


The error can be caused if the Excel EuroTool Addin (Eurotool.xla or Eurotool.xlam) is active in Excel.


If the Eurotool Add-in is unselected in Excel. DataPA works normally.


Note: Please advise DataPA if you require the Eurotool Add-in to be enabled. We are investigating the incompatibility between the two Add-ins.




Need a hand?

We’re here if you need a little more help.

Contact support ↗