Maxim Zelensky on 13 Sep 2017 20:20:24
is there a possibility to NOT load totals rows from Excel table?
I'm ususally do not use totals in tables so wasn't aware, but now met an unpleasant situation when unfiltered totals row causes problems.
I understand that we can filter it out after loading (but sometimes its existence could be recognised only with eyes, not automatically by values), but from my VBA experience these are different properties of ListObject: ListObject.DataBodyRange and ListObject.TotalsRowRange.
It could be great if we'll have a possibility to manage somehow, whether we want to import totals row from a table.