The way to find out about our place in the universe is by examining the universe and by examining ourselves - without preconceptions, with as unbiased a mind as we can muster.
In one excel workbook I have several pivot tables getting data from one large table. When I hit refresh or refresh all, every table loses their filters no longer provides an option for filtering by month, year, or quarter and the data displayed by the table is not desired. How do I correct this from happening? I want each pivot table to continue to updated the subtotals for each month as new data is added to the main table.
Damon LeeOP
@Reply 4 years ago
I figured it out. Some of the data feeding the Pivot Tables, had "#Value," errors. Once I updated their formulas using, "IFERROR" functions, the "#Value," errors went away and the pivot tables went back to using the "year" filters displaying the information correctly.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
