If there's a line a subtotal in the report, have it show as a formula when exported.  If your have one column subtracting from another - keep it when exporting the report.  We often do some edits once it's in excel, and we need to go in and add those formulas because everything is stored as values.