At the 13:30 mark when making formulas from a PivotTable, if you want cell references, rather than GetPivotData, change settings: File, Options, Formulas, then uncheck checkbox for "Use GetPivotData functions for PivotTable references".
Another interesting and informative video.Thanks for taking the time to record and post these useful tutorials. I wish that I had run across more teachers like you when I was at school, I might have been a more enthusiastic pupil!
Good video, Mike! At the 13:30 mark, many people might end up getting Pivot Table formulas when they refer to the cells in the PT. They need to change the settings for Generate GetPivot Data.
@@Al-Ahdal I am sorry but I do not have time now to do this... : ( I can't wait to make a video about this, but I have too much other trouble right now... : (
@@excelisfun, I pray for you boss, and wish that you will be out of trouble very soon. Whenever you convenient, kindly guide us on this. Thanks and best wishes always.
At the 13:30 mark when making formulas from a PivotTable, if you want cell references, rather than GetPivotData, change settings: File, Options, Formulas, then uncheck checkbox for "Use GetPivotData functions for PivotTable references".
No I don’t. ;-)
Great video, and great lesson, too. :-)
@@GeertDelmulle Thanks, Teammate!!!!
Thanks Mike for this EXCELlent video.
You are welcome, Fellow Teacher : ) : ) : ) : )
Thanks Mike!!! Great and informative Video!!
You are welcome John "Formula Guy" Borg!!!!
Get well soon Mike! You are making some useful videos. 👍
Thanks, Mark!!! I am glad that the videos are useful for you!
Back in style like a top class Yanaki boomerang. Great video!!✌😉
Top class Teammate, that is you : )
Another interesting and informative video.Thanks for taking the time to record and post these useful tutorials. I wish that I had run across more teachers like you when I was at school, I might have been a more enthusiastic pupil!
It is so TRUE: Teachers with enthusiasm and good story telling ability can make all the difference. Thanks for watching and enjoying, Roy!!! : ) : )
Good video, Mike! At the 13:30 mark, many people might end up getting Pivot Table formulas when they refer to the cells in the PT. They need to change the settings for Generate GetPivot Data.
Oooo... Bummer.... I TOTALLY meant to mention that, but I totally forgot. I might be getting too old to teach : (
Thanks for the tip, I pinned an "old man forgetful" comment to the top lol
Go Team!!!!!
@@excelisfun o good Lord! You'll never be too old to teach.
@@drsteele4749 We'll see about that lol
I wish, I could learn it earlier from you....But no worries ...I'm learning now ❤️🙌
That is right. We are here now!!!!!! : ) : ) : )
NEVER go a day without learning something! For Excel you could watch all of Mike's 1.9 billion videos and you'd be covered.
Boom!Awesome Fun Statistical Class...Thank You Mike :)
You are welcome, Mountain Biker Teammate!!!!
Another EXCEL-LENT video MIke! The team keeps getting better!
Go Team!!!! Thanks as always, Chris M : ) : ) : )
Hi Mike. Another great one! Thanks for this enthusiastic and informative lesson. Hope you are feeling better :)) Thumbs up!!
Still feeling bad, BUT, making videos for the Team keeps me going : ) : ) : )
@@excelisfun Thanks Mike! Appreciate all your efforts and hope you feel better soon :)) Go Team!!!
How are you feeling Mike? Thank you so much for the superb video as always.
You are welcome! I am still not well, but at least I am making videos.
Thanks!
In missed to do my bit, done ✔
Thank you very much, Santosh for helping me to make videos!!!!
You do your bit, and it helps a lot : ) : ) : ) : ) : )
3rd :)
I cant wait :) to see whats up
Thanks, Radoslaw : ) : ) : )
@@excelisfun your welcome :)
1st
Trophy goes to you!!!
@@Al-Ahdal I am sorry but I do not have time now to do this... : ( I can't wait to make a video about this, but I have too much other trouble right now... : (
@@excelisfun, I pray for you boss, and wish that you will be out of trouble very soon. Whenever you convenient, kindly guide us on this. Thanks and best wishes always.