Is it possible to utilise data in Excel in Power Query without it turning into a table?
The data to be used will be appended to and/or rows deleted and doing this via VBA as a table is painfully slow, especially when deleting table row even with everything turned off that would slow it down.
The query will be refreshed fairly regularly with the updated data-set so I need this to be as slick and quick as possible.
TIA
The data to be used will be appended to and/or rows deleted and doing this via VBA as a table is painfully slow, especially when deleting table row even with everything turned off that would slow it down.
The query will be refreshed fairly regularly with the updated data-set so I need this to be as slick and quick as possible.
TIA
