I have an XML import table with 11 columns and a variable amount of rows. I need to keep the table sorted so that column 6 "Sort Largest to Smallest" arranges the table, (column 6 only has two values: 0 & 1) then I need it to be sorted by column 7 "Sort Largest to Smallest" (Column 7 has many possible values).

This isn't a problem to set up, but any time the XML connection is refreshed, the column format is lost. I need to find a way to "Lock in" the sort rules, so that they sort in the correct order (column 6 then column 7) and a refresh doesn't wipe either rule.

Any help with this would be amazing.