I am using an Excel 2007 pivot tables for reports on a simple income / expenditure bookkeeping system. When I remove all data from the Income and Expenditure tables for the user to start from scratch the pivot tables loose their grouping and filter settings.
Any help on how to overcome this problem would be much appreciated.