New Data Connection - Not converting To a Table

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,457
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
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Watch MrExcel Video

Forum statistics

Threads
1,108,738
Messages
5,524,549
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top