Retro - Create old-style query in PowerQuery?

[David1906]

I've been linking and manipulating data in Excel since Office 2000, but I am stumped at trying to re-create in O365 something I once made in O2K. I had a query that would pull data into Excel, and then added subtotals to the table, all controlled through a VBA macro. (Relevant VBA commands: Range(TopCorner).Select, Selection.RemoveSubtotal, Selection.QueryTable.Refresh, and then Selection.Subtotal)

Power query only makes modern Table objects that cannot have subtotals. Is there any way to make a query in Excel that does not end up as a ListObject Table, and that can be manipulated the way I used to? Thanks.

[edhans · Accepted solution]

No. You'd need to bring the data into the Excel Data Model, then create a Pivot table using that model (Power Pivot) which can have subtotals.

All tables created by Power Query or consumed within the same file are a ListObject Table for VBA.