We build Excel 2010 spreadsheets with pivot tables in them referencing an OLAP cube as the data source. We use manual filters to choose several GL acount numbers. When we are done we save the spreadsheet.

We have reopened several spreadsheets from a couple months ago to over a year ago and when we look at the pivot table the filter selections (check boxes) are pointing to different accounts than they were when we created them. How can we retain the original selections so that we can easily pull up the spreadsheet and refresh to just pull in the latest data for the selected GL accounts?

Thanks!