Bother you have no idea how I'm glad that I was able to help you. Please share the video, subscribe to my channel and watch so many other amazing tutorials.
I am unable to get the excel functionalities in PPT. I followed all the steps, when i double click on the pivot table in PPT, the excel worksheet opens and the functionalities of excel do not appear in ppt
4:41 When I am double clicking on pivot table in PowerPoint it's opening in the Excel and not inside the PowerPoint with all the excel ribbons like in the video. If anyone could please help me how to correct the same? I have followed all the steps as mentioned in the video
When I double click on my pivot table in PPT it opens up an excel file instead of staying in ppt. My chart isn't dynamic in ppt, but it is in the excel that opens up. What am I doing wrong? Thank you for the wonderful video!
Same here. I've spent almost two days to replicate this and am starting to think that it's a customised add-in rather than a published feature of Microsoft, which makes this rather misleading.
@@ANNI391 That's exactly what happens. You are not doing anything wrong and it means that linking the table in PowerPoint is almost pointless because you can't really do anything with it - you're better off presenting the Excel sheet. Also it doesn't work in Presentation mode and no interaction with the table is possible in presentation mode.
Thank you By the way, what is Digital Cooking? Why do you need Excel for that? It might be interesting creating Interactive recopies in Excel... email me at info@officeinstructor.ca
Thanks for your wonderful step by step instructions to embed pivot table from excel to PPT. But it is not refreshing automatically when excel data and pivot in Excel changes. While double click on the embedded table in PPT, getting error "There isn't enough memory available to read Worksheet ". Any tips to fix this please
Useful for certain presentations for sure. It's a shame MS don't allow the slicer to be fully interactive without needing to go double click into the embedded object first. Maybe one day ....thanks for your video 👍
Good morning, fantastic tips but i have a question. I currently use office 365 but i don't have pivottable options. Is the add-on avaible on office 365 ? In add, i would like to know if you are able to see the entire pivot table in powerpoint even if it changes its bigger than the original dimension? thanks
Very good video. Question though: If you were to take that PowerPoint slide and set it to Slide Show Mode, I assume that you can interact with the slicer should you be giving an overhead presentation.
It can also be Interactive in PowerPoint during Slide Show mode. This is more to the PPT side than Excel . Watch the article created by Muhamed Suhaily using my Tutorial as an example where he continues building interactivity in PPT www.linkedin.com/posts/muhammad-suhaily-george-abdullah-64235132_excel-exceltips-microsoft-activity-6698425034941313024-X6hQ
If the file size is big in excel, after bringing the entire pivot table to powerpoint, it is not supporting the memory in PPT. may I know if there is any way to follow same for big data size?
It can also be Interactive in PowerPoint during Slide Show mode. This is more to the PPT side than Excel . Watch the article created by Muhamed Suhaily using my Tutorial as an example where he continues building interactivity in PPT www.linkedin.com/posts/muhammad-suhaily-george-abdullah-64235132_excel-exceltips-microsoft-activity-6698425034941313024-X6hQ
You should mention that each time you embed file in ppt file it's size is growing rapidly, so you can easily end with file that's 50mb and you can't share it via email
Hello sir, When I double click the pivot table within PowerPoint, it opens excel, rather than giving me the excel ribbon within PowerPoint. It was working fine the other day but today I am having this issue. Any idea what I am doing wrong?
If slicer can not work in presentation mode then what is the benefit of the slicer to attach with graph, you just fool people this was about how to work with charts in power point but you just cleverly mold it to that you are going to change the game.
Whole essence of Video is missing here. Do you really think you will double click & select slicer during your presentation ? Not the best idea, right ?
The accent & explanation you use in your video is understandable in every corner of world.
Thank you
So simple way of teaching and clear vocals. Thanks Nabeel
Thank you
Nabil, your videos are truly amazing, thanks for your enthusiasm and for sharing.
Thank you for the motivating comment
I was in search for this trick.... Thank you Nabil
Bother you have no idea how this presentation helped me...ur insane man bravo!!!
Bother you have no idea how I'm glad that I was able to help you. Please share the video, subscribe to my channel and watch so many other amazing tutorials.
Thank you Nabil. A great video!
Thanks - I liked your explenations!!!! Cleer & Bright!!!
Can we run this dynamic pivot table and slicer in slide show mode as well?
I was searching for just this thing and finally found it here! Thanks a lot Nabil! You are great! 😊👍
My pleasure 😊
What a. Wonderful exercise, ! you are simply superb!!!
Thank you so much!
Totally appreciated
Excellent video with great clarity !! Thank you very much 🙏
Excellent !!! Excellent !!! Excellent !!!
Thank you !!! Thank you !!! Thank you !!!
Perfect explanation, it was exactly what I needed, no one have the answer besides you, congratulations
great content love this wish you have more subscribers
I appreciate that!
Great video! Thanks so much for sharing! It was really helpful!
Glad it was helpful!
Exactly what i needed, can't thank you enough🙏🏻
So clear and concise, I love it!! Thank youuu
Glad to hear that. Kindly share on your social platforms and subscribe
I am unable to get the excel functionalities in PPT. I followed all the steps, when i double click on the pivot table in PPT, the excel worksheet opens and the functionalities of excel do not appear in ppt
@@nafa1531 Are you using office 2019?
it is the only version that does not work like the tutorial. Earlier versions and later versions do.
This was an awesome explanation and excellent feature which i was looking recent days :)
Thank you so much 👌👍
This is too good!! Thank you !
Thank you too!
You are amazing brother
4:41 When I am double clicking on pivot table in PowerPoint it's opening in the Excel and not inside the PowerPoint with all the excel ribbons like in the video. If anyone could please help me how to correct the same? I have followed all the steps as mentioned in the video
Same
Is the interactive function still working on presentation?
When I double click on my pivot table in PPT it opens up an excel file instead of staying in ppt. My chart isn't dynamic in ppt, but it is in the excel that opens up.
What am I doing wrong? Thank you for the wonderful video!
Same thing for me !!!
ditto is there an answer?
Same here. I've spent almost two days to replicate this and am starting to think that it's a customised add-in rather than a published feature of Microsoft, which makes this rather misleading.
@@ANNI391 That's exactly what happens. You are not doing anything wrong and it means that linking the table in PowerPoint is almost pointless because you can't really do anything with it - you're better off presenting the Excel sheet. Also it doesn't work in Presentation mode and no interaction with the table is possible in presentation mode.
Mr. Nabil perfect!!!👍👍👍
Thank you
By the way, what is Digital Cooking? Why do you need Excel for that?
It might be interesting creating Interactive recopies in Excel...
email me at info@officeinstructor.ca
@@Officeinstructor like you I use surname DIGITAL COOKING when people cook with Vegetables in accounting we cook
with numbers 🙂
very cool! thank you for sharing.
THANK YOUUUU!!!!!! NABEEL
Thank you so much.
super cool!
Awesome, thanks.
You are welcome ya basha
Very Good 👍
Thank you
Excellent Sir
Great Video.
Very concise. Much appreciation.
Excellent dear sir. Thanks a lot.
Glad you liked it
Superb...👍👍
Thanks 🤗
How do i hide the pivot table and show just the dashboard with slicers?
Awesome 👍👍👍
Thank you dear friend
Thanks for your wonderful step by step instructions to embed pivot table from excel to PPT. But it is not refreshing automatically when excel data and pivot in Excel changes. While double click on the embedded table in PPT, getting error "There isn't enough memory available to read Worksheet ". Any tips to fix this please
Thanks Subramanian... and you are right it does not refresh automatically.
Did you Subscribe to the channel?
Excellent👍
Very Nice!
what is the name of the screen recorder your are using?
Useful for certain presentations for sure. It's a shame MS don't allow the slicer to be fully interactive without needing to go double click into the embedded object first. Maybe one day ....thanks for your video 👍
Agree
Yes, and when you do double-click, all hell can start running loose 🙃
Thank you!
Is it possible to hide the table and just display the slicer & chart?
The best. God bless you:) What a superb presenttion
Thank You
Great work Sir thank you
Nice
Thanks!!!
Welcome!
Good and useful.
but.. how can select the slicer tabs when doing PowerPoint show..?
can make trigger/link by clicking on slide page..?
This is amazing, Nabil! Does the slicer functionality work on presentation mode as well?
Unfortunately NO... That would be a game changer
This my question too
@@Officeinstructor ✅ oo
Thanks a lot
You are welcome
Awesome!! It really helped me in my presentation😍🥰
Great that I came across this option. But I am missing embed option in my power point. Any one knows why and how can I have it ? Thanks!!!
I found the embedded icon under the Paste drop down in the Home ribbon but it still try’s to open the spreadsheet in Excel when I double click
Thank you Celia for the interaction
Does this work on 2016 version?
Yes it should
Good morning, fantastic tips but i have a question.
I currently use office 365 but i don't have pivottable options. Is the add-on avaible on office 365 ? In add, i would like to know if you are able to see the entire pivot table in powerpoint even if it changes its bigger than the original dimension? thanks
Options is available in Office 365
Great😍😍😍, Just I wish I could have the functionality of slicer in view mode.
That would have been more amazing
Wow.. Wow.. Wow.. 🌟 🌟 🌟
You are a legend..
I am very grateful to you.
Your tutorials are unique and always useful.. Best regards. Salim.
Thank you Salim
Great, fantastic!
Why after I click the embed table, it pops out the Excel window but not the bar in the ppt?
Thank youuuuuu so much
unable to get embed option while pasting, cab anyone help?
Good solution for a common problem. ...but I got error message when I clicked the pivot border on PPT that " no sufficient memory "....
Very good video. Question though: If you were to take that PowerPoint slide and set it to Slide Show Mode, I assume that you can interact with the slicer should you be giving an overhead presentation.
It can also be Interactive in PowerPoint during Slide Show mode. This is more to the PPT side than Excel . Watch the article created by Muhamed Suhaily using my Tutorial as an example where he continues building interactivity in PPT
www.linkedin.com/posts/muhammad-suhaily-george-abdullah-64235132_excel-exceltips-microsoft-activity-6698425034941313024-X6hQ
Yes, I agreed with you. But the way, we can use Power BI to do the presentation as well.
when I double click the pivot using PowerPoint, it opens the original excel file, how can I fix this to enable me to edit inside PowerPoint?
when i double tap on the sheet it take me to the same excel sheet where actually that Pivot is post pasting the excel sheet as embed
Are you using Excel 2019?
The functionality works in previous and in later versions (Microsoft 365) but not in this one.
Can we hide the table here?
How to remove or hide filter icon in heading in ppt.
Can i ban coming back to excel again after finishing my project ?
Thanks for that I easy way.
The practice file link is not working
Here you go:
officeinstructor.com/pivot-table-in-powerpoint/
Nice insights.
Can you advise how to create a dropdown list for use in edit mode not presentation mode?
when I double click on the pivot table, it just re-opens my excel file. I don't get the integration that you are getting.
if you are using Office 2019, it will not work. It works in all versions Before and And after (Microsoft 365) 2019!
when i pasted excel to powerpoint i can not see function excel to powerpoint sir
If the file size is big in excel, after bringing the entire pivot table to powerpoint, it is not supporting the memory in PPT. may I know if there is any way to follow same for big data size?
I did not try with a big file size.
Marvellous ..
any version from office i need to can do this ?
For this tutorial I used Office 2016
Thank you :)
Azim Gedan Thanks alot
your worksheet is not behind https
how to insert Analyze Tab
Maybe it would be better to transfer advertisements and descriptions to the end of the video. Thank you for your nice video. :)
Excelent video. Thnks!,, But... how can update the data (or add new data) and have the chart and presentation to update automatically?
they can't work in slide show right ?
It can also be Interactive in PowerPoint during Slide Show mode. This is more to the PPT side than Excel . Watch the article created by Muhamed Suhaily using my Tutorial as an example where he continues building interactivity in PPT
www.linkedin.com/posts/muhammad-suhaily-george-abdullah-64235132_excel-exceltips-microsoft-activity-6698425034941313024-X6hQ
the best
Cristal clear
Glad you liked it
Asomax!!
Did you subscribe to the channel?
@@Officeinstructor yes ofcourse
Sad… it will not work in presentation mode, for it quits Excel editor
I wish I cud hug u dear Nabeel
Just come to Toronto and I can make your dream come true
Interesting and yet not useful. But excellent stuff.
You should mention that each time you embed file in ppt file it's size is growing rapidly, so you can easily end with file that's 50mb and you can't share it via email
Nice. But I do it in excel instead.
Hello sir, When I double click the pivot table within PowerPoint, it opens excel, rather than giving me the excel ribbon within PowerPoint.
It was working fine the other day but today I am having this issue.
Any idea what I am doing wrong?
If slicer can not work in presentation mode then what is the benefit of the slicer to attach with graph, you just fool people this was about how to work with charts in power point but you just cleverly mold it to that you are going to change the game.
This did not work is 0ffice 2021
WHENEVER I DOBLE CLICK TAKES ME BACK TO EXCEL
Whole essence of Video is missing here. Do you really think you will double click & select slicer during your presentation ? Not the best idea, right ?
Awesome 👍👍👍👍👍
Thank you!