Quick analysis for query table changes type on refresh

Occasional Visitor

Hi everyone,

 

I'm using Excel 2016 and have created connection-only tables that are refreshed when the workbook is opened.  I have previously right-clicked on the table and chose "Quick Analysis" and chose "Sum".  This correctly adds a new sum row to the table and sums the column I want. Great.

 

However, when I save, close and re-open the workbook, the sum row changes to be "Total" and just gives me a count of the number of rows.  How can I stop this from happening and keep "Sum" as the Quick Analysis row?

 

Thanks,

Tim

0 Replies