Try opening a new empty workbook and try the Access INXL Get Data and or Get Detailed Data functions in a fresh workbook.
If this works, then it may be an issue in the existing workbook.
If it is practical to do so, then work using the newly created workbook rather than the pre-existing one that had the error.
