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,