I have a table that I need to export to excel. Issue is that when I create a macro to export from the table it loses the sort order. Trying to export with formatting replaces my existing spreadsheet rather than updating it.
What are my options with exporting from a query? I do not have the same options available if I choose to export from a query instead of a table using the importexportspreadsheet option.