Common Pivot Table Problem... and Stunning Solutions
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- In this tutorial I tackle a very common problem that happens when creating more than a single pivot table using the same source list. I show you different methods for fixing this problem and I explain why it happens...
You can Download the exercise file and follow along by clicking on the link
officeinstruct...
You can also read the article about this problem and the different ways to resolve it on my blogsite by clicking on the link:
officeinstruct...
Explore other articles as well on my blogsite and make sure to subscribe to receive an immediate copy of my Textbook: "Pivot Tables... From Zero To Hero" at www.See-How.ca
You can also register to upcoming Free Live webinars as advertised on my website www.See-How.ca
To book a Corporate Training and receive my course catalog visit my website www.OfficeInstructor.ca
This channel is created for you "Excel Lovers"... and it can only continue with your motivation and feedback: So, Like, Share and comment... and don't forget to hit the big subscribe button to be notified when new videos are released... The Best is Yet To Come.
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.4 (4/4)](http://i.ytimg.com/vi/d3l5rxl5CVo/mqdefault.jpg)
الذكاء الاصطناعي أشكر د. نبيل أنك خبير حقيقي
حبيبي يا غالي
ألف شكر لمتابعتك
Ma Shaa Allah
Excellent sir
May Allah shower His blessings upon you...
Help all of us to master in Microsoft Excel
Excellent and skillful presentation. It solved a problem I was struggling with before submitting annual reports.
Glad it helped!
Thank you, you solved my problem
Amazing Sir…many thanks U r the best teacher I would say👌
Very well explained. Thank you so much. This was helpful fixing the the issue in my pivot table
Glad it helped!
Awesome. Though I've been working with Power Pivot for a year now, I never paid attention to differences in pivots' caches until now. Thanks Nabil.
Brilliant! I occasionally have this problem and resolve it a bit differently, but your solutions were simple and yet powerful!
I'm thrilled from this nice comment from an expert... Thank you Joy
Very well done
Thank you very much!
Beautiful tricks. Tank you Nabil!
Wonderful. Nice explanation. Thanks a lot.
Aoa Really great way to teach the difficult logics and techniques in simple and easy to understand. Thank you sir
you help us a lot.. thank you
Really well explained, loved it.
Glad you liked it!
Good work. I like it
Thank You Sir for uploading these helpful videos,
please make a video on HR attendance sheet & over time calculation sheet. There are a lots of videos on youtube but we need from you because your tricks and formulas are very easy and understandable.
Nice video.
But what about if you don't have Power Pivot as many people don't? And secondly, isn't it simply easier to copy/paste first Pivot table as many times as possible within workbook?
I have been taught that on courses, and I am using it, it works without any problems. XY times having Pivot caches on one sheet is fine, especially if you wanna have XY charts/slicers/timelines.
Thanks Nabil. Good take away. Looks that power pivot have muscles. Will need to study out more about power pivot.
thank you a loot sir .kindly can you make a video abut KPIS ?
Glad you liked it ya Reda Basha ... Stay tuned... The Best Is Yet to Come
May the heavens watch over you for the good job that you're doing. Thank you !
Please, is there a pivot slicer tool in Window 7? If yes, how do I locate it? Thanks.
Nice, thanks! Can you please upload the Exercise File? Your Link is not working. Thanks
Hi very interesting but cannot download your file
exclant .. but calculated filed not actvie with method number 3 ?
AN EYE OPENING VIDEO ON PIVOT TABLES OPTIONS SIR
I HAVE A QUESTION SIR CAN THESE DIFFERENT PIVOTS BE LINKED WITH ONE SLICER SO THAT SELECTION IN PIVOT REFLECTS IN ANOTHER I KNOW I SOUNDS SILLY BUT I REQUIRE LIKE THIS😈😈😈
Yes, you can name each Pivot Table, then select a slicer >> Right Click >> Network Connections >> check all Pivot Tables
Please, could add the captions with this video, it's a simple button to click on ... I'm deaf :-) . Thanks a lot :-)
Sir, I have a problem with my MSOffice 2007. on any of mytabs icant get the slicer...why? can you have some solution... I will be pleased to here it from you... thanks
Slicers were introduced into Excel for the first time in Office 2010, then you do not have it in 2007
Mr.Napil kindly i have a problem when I want to refresh the data model. I have been always receive a massage sayed that(we couldn't refresh tha data model from its source)
Kindly help me how can I solve this kind of problem
i am using powerPivot Table option for grouping date but its not active, apply in different file, can you tell me why is not active?
One of my recurring issues with pivot tables is transferring them to ppt without losing functionality and without PowerPoint or the individual slide going all crazy 🙃😒 if Word acts weird when you move images around, PowerPoint acts like a genuinely dumb person trying to figure out life through their monodimensional thinking 🤔 like dude wtf are you doing? How are you handling things so badly??? Whyyyyy?