Forum Discussion

___cf's avatar
___cf
Copper Contributor
Jun 04, 2020

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 adjusted to the rows count after a refresh.
Now it's returning just one row and after that, I'm getting #REF! errors instead because all formulas lost the query area.
I've 100+ reports working in hundreds of customers, being updated since Excel XP that isn't working because of this "upgrade"... if it's not broken, don't fix it!
MS should return to their previous working scheme of two rows minimum and better yet, add a REAL row count, instead qt.resultrange.rows.count

excel

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jun 04, 2020
    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?

Resources