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?