Pivot Tables and clearing filters/filter cache with multiple tabs

TDoug

New Member
Joined
Sep 30, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have been reading the posts about issues with pivot table filters being deselected when new data comes in. Our source is from an analysis services site. If the following month the item that was deselected is applicable, then we have an error. I looked into the clear cache, clear filters, etc. My question is this. The business has multiple tabs on the spreadsheet with the same pivot table; however each tab might have a group of products selected. For example, one tab is all the color Yellow. The other tab is all the color red. The whole data set for the pivot table has yellow, red, blue, and green.

If I do do any clear filters...wouldn't it clear the filters on every tab so the business would lose the filter on the first tab of Yellow and the second tab of red?

Any thoughts?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,212,938
Messages
6,110,782
Members
448,297
Latest member
carmadgar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top