Slicer Pivot Table Cache Relationship and the Filter Controls Error

[@ulkarqazen1470]

Thank you! I've looked all over for this info & finally I found info on how to modify source data on linked slicers.

[@LotfyKozman]

Thanks for the video and for clarification. Your explanation is very clear, concentrated, and hits the goal with great accuracy.

[@ExcelCampus]

Thank you Lofty! I really appreciate the nice feedback. :-)

[@lucymokabane843]

Excel Campus - Jon I am using excel 2007 I don't have slicer on ribbon. How add it to appear on the ribbon?

[@davidgear3101]

Excellent, very helpful and well described the issue and the solution. This solved the problem I was having perfectly.

[@Fintech20246]

It's really very good video course ever. THANKYOU

[@PERUTICA2011]

Excellent! Nice explanation, thank you for sharing your knowledge

[@genius007ufo]

Thanks for this great video and explanation.

[@lailauzule]

I love Excel Table :) It's good as for Pivot Tables and for other situations too.

[@ExcelCampus]

Yes! Me too Laila. Tables are a real time saver for lots of reasons. I have another video that explains Tables in more detail. kzbin.info/www/bejne/nHvRe4ecm5mBl5o

[@rizkyramdhany4549]

Thnks, it help my daily work :)

[@desairushabh936]

Hey Jon, It was really helpful content. Though, during the video, the report data was changed as we changed the state. I was just wondering if you can share the link on that how to change the data as per any specific selection. I would really appreciate that!

[@franciscahill5868]

Thanks this is exactly what I was looking for!

[@ExcelCampus]

Thanks Francis!

[@anitaramer9465]

Very good video! I'm trying to figure out how to update the data with more lines. How do I name the table when the file is already set up and then how do I get the pivot and slicers to read that table? Anita

[@leanderhowardii6308]

Also, the first data source you showed was a table but didn't do what you showed at the end of the video where it would update the data automatically for you to not have to change the slicers. Correct me if I am wrong, please. Thanks for all your help. I think I see, the first data source is just filtered? The way you are telling us you created a table for the data source. Is that correct?

[@tassaneeto]

I have to add weekly in the report and also the Table for my data. But sometimes when i add the new data in table, the tabel range is not cover my new data. Sometimes can but sometimes cannot. I am not sure what was wrong. Pls help to advise. Thank you for your video and advice.

[@velidoshi1535]

Hi do you have a video on "how to make excel tables? Please share link.

[@leanderhowardii6308]

Is there a way to know which pivot tables have a relationship with one slicer?

[@SGEVOL]

Thanks for the video. I am aware we need to use a table for slicers so that we do not have to update the data source (therefore I tried to use pivot table on the source data as slicer). My objective is to want the slicer to be updated automatically once we click 'refresh'. How do we do that?

[@leanderhowardii6308]

Great video bro. So simply making your data source a table will fix the problem? I am a financial analyst and this could solve my problem of having to update slicers every time we pull new data from Tableau into excel. I look forward to your answer

[@rajkishormahanada6223]

I have created multiple slicer and connected to multiple pivot table but one of the slicer not return correct value of table. Can I know how to find the error

[@cnh8039]

What to do when this errors comes when we are creating filters for slicers , where we delete the original pivot table and also even though we convert table into excel table in the middle of the process that is when we get this error , does it work ?

[@INFANTEFINANCIAL]

Concise explanation and excellent delivery Jon! Thank you! my question now is if its possible to have a shared slicer between pivot tables that come from multiple data sources (different tables in different sheets) if they have a shared data connection (through pivot table)?...would this data connection act as the shared Pivot Cache?

[@ExcelCampus]

Hi, We can only have shared slicers between pivot tables if the pivot tables share the same pivot cache and data source. We can use Power Pivot to create relationships between data sources, and then use those slicers on multiple pivot tables.

[@LotfyKozman]

It will be great if you can start new series about DAX formula and Getpivot & Cube functions in Excel.

[@OzduSoleilDATA]

Once again, the answer is to USE TABLES!

[@ExcelCampus]

YES!!! :-)

[@rehanbabar171]

What if we want to add a column in Pivot Table?

[@hussainzahwa8525]

Dear, thank you for your explanation, still i face issue when I updated my sources data, could you please provide me your email address. Thanks