Good day,
I am having a small problem with my pivot tables,
I created a table, and set up a pivot table data source to pull from the table,
I made sure the raw data is considered to be part of the table,
I turned the table into a range and back into a table to make sure it all accounted for,
I made sure it is named correctly,
I check the formats for the table and they all concur,
however when i refresh the pivot table, it only pulls to a certain point,
When I run my macro that refreshes the cache, I get an error, So I am guessing its an error with the cache not updated,
what can I do in this case other than delete the pivot and remake it?
Thanks in advance,
Bookmarks