Getting the Subtotal window to remember values previously entered

    How do I get Excel to remember the settings I enter in the Subtotals window? I have dozens of reports that I go through and refresh data from Microsoft Query on a weekly basis. When I go to restore my subtotals (through the ‘Data’…’Subtotals’ menu), it never defaults to the previous for ‘At each change in’, ‘Use function’, and ‘Add subtotal to’ fields. This is a minor time-consuming nuisance, but I sure would be grateful for any suggestions.


    Thanks!

    Re: Getting the Subtotal window to remember values previously entered


    Try recording a macro to capture the settings that you are making the next time you apply the subtiotals. Then after future refreshes, use the recorded macro to redo the settings and show the subtotals.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login