Excel 2016 RRS feed

  • Question

  • Hi

    I am using Excel 2010 querytable to retrive data via SQL database. In this Excel version, whenever the result set is empty, it will return 2 empty rows, This works well when I used range formulas such as sum, subtotal, range names, etc

    When I switch to Excel 2016 and above, only 1 row is returned for empty result set and on the next query when the result set is non empty, the range formulaes does not work anymore.

    Please do not suggest switching to table list objects as there are just far too many worksheets to change.

    Many thanks for your help.

    Tuesday, July 30, 2019 2:20 AM