peglegpete
New Member
- Joined
- Dec 4, 2005
- Messages
- 13
I have a bunch of pivot tables in a workbook with charts based on those pivot tables. I wrote a VBA subroutine that changes the page filter in pivot table, and then makes picture copies of the charts into a new workbook. This worked fine for a while.
A problem developed recently though. The pivot tables seem to have become corrupted. Specifically, the page filters no longer accurately reflect the field they are filtering on. There are exactly 10 different text values for the field the page filter is based on, but the pivot table only shows 8. If I go to the source data table, there are values listed that are simply not being captured in the page filter list.
I have tried refreshing the pivot table and resetting the source data range. Neither fixed the issue. If I rename one of the missing values to something else, just for test purposes, it will show up in the page filter list. If I change it back, it will go missing again.
It seems like my only remaining option is to rebuild each pivot table from scratch. I have 15-20 very specific tables created. Recreating those tables is a lot of work and thus not my preference, especially if they eventually end up with the same problem.
Has anyone else experienced this problem? What are my options for fixing this, or preventing it from occurring?
I haven't had much luck finding info on this issue on the web.
A problem developed recently though. The pivot tables seem to have become corrupted. Specifically, the page filters no longer accurately reflect the field they are filtering on. There are exactly 10 different text values for the field the page filter is based on, but the pivot table only shows 8. If I go to the source data table, there are values listed that are simply not being captured in the page filter list.
I have tried refreshing the pivot table and resetting the source data range. Neither fixed the issue. If I rename one of the missing values to something else, just for test purposes, it will show up in the page filter list. If I change it back, it will go missing again.
It seems like my only remaining option is to rebuild each pivot table from scratch. I have 15-20 very specific tables created. Recreating those tables is a lot of work and thus not my preference, especially if they eventually end up with the same problem.
Has anyone else experienced this problem? What are my options for fixing this, or preventing it from occurring?
I haven't had much luck finding info on this issue on the web.
Last edited:
