Forum Discussion
Issues with QueryTables in Excel 2019
Prior to Excel 2019, querytables returned at least 2 rows, even with empty recordsets. This way subtotals and other formulas that depend on the dynamic number of query rows are automatically adjuste...
Can you perhaps post an example where -using the same dataset- we might see the difference between how an older version of Excel worked and how 2019 works?