I created a macro to export a query with a total to an Excel file, but the total does not show on the exported file. I did use “export with formatting “ so am not sure why it doesn’t work. It’s the same query underlying a report, and the Total works in the report. Any ideas appreciated!