Jun 03 2020 05:35 PM
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
Jun 04 2020 06:00 AM