Hello:

I feel I should know this but I don't.

When I export a GridView query to Excel, the column total is a number rather than a formula. The "ExcelDirect as table (XL 2007 or later)" option = On.

When I use ExcelDirect on a grid, the Excel table has Subtotal() as a formula for the totals. This makes the Excel Filter function more effective.

Question: How can I configure GridView to export a column total as a formula?