Hi and welcome to the forum.
While you cannot create Autofilters in exported Excel files with v8, you can do it with v9.
As for exporting totals, you cannot do that in the Table view; you can only do that with a Summary. You could spend a couple of minutes and design a summary which might not have exactly the same field order as your table does, but you it's very likely that you'll be able to include all of the fields that appear in your table in your summary.
One further nicety available in v9 is the ability to export the totals as formulas. If you need to do a little "what-if" with the detail amounts, the totals will recalculate as is normal when working in Excel. Version 8 exports the totals as values, not formulas.