Auto Refresh Pivot Table | How to Refresh Pivot Table automatically when source data changes Excel

[@nitinshukla914]

SirG, mai bade dino se isi Auto Refresh ka Tod dundh raha tha. Meri pyas keval aapke is video se hi buzi hai. Shat Shat Pranam. Dhanyawad.

[@Innozant]

Thanks Nitin Ji,Hope Apke life me value add karta hai ye videos aur aapnroj naya Kuch seekhte Hain ♥️🙏

[@keshariprasad1992]

U r truely master of MS excel. 👏👏👏

[@Innozant]

Thanks dear .Keep learning

[@DEADYBOYS]

Sir ji Love you 😛 Ishi ki kami thi but ye mujhe pehle se pata tha aap bahut achcha Teach krte ho

[@Prem_P_Bhatta]

The way you trying to teaching is very simple and easy I'm very very thank you

[@Innozant]

Thanks Prem

[@ShamimKhan-pn3vy]

Excellent sir solute for u . very clear and understanding quick explanation

[@Innozant]

Thanks..keep learning

[@roshanthakare7051]

Aap ka bat karne ka tarika lajawab hai sirji
🙏🙏🙏

[@Innozant]

Thanks Roshan

[@manjuh4621]

You are the Best Teacher 🔥🔥🔥🙏🙏🙏

[@Innozant]

Thanks dear

[@rohitgusain8810]

You are so underrated 🙏🙏🙏

[@Innozant]

Koi nahi..thanks.keep learning

[@parthomodi9241]

Bohot Bohot Shukriya aapka. It was a very wonderful and informative tutorial.

[@Innozant]

Thanks Partho 👍❤️

[@sandeepaswal8944]

Sir Your Knowledge Always super. Word nahi mere pass. You are Great. You are my favourite teacher. Aapkai videos suru sai dekhkar etna gyan hogaya hai muje. Bata nahi sakta aapko. You changed my life.

[@Innozant]

Thanks Sandeep Ji,God bless you dear,Khume value add kijiye saath hi Anne aas paas ke logon me bhi yhi successfull hone Ka asli matlab hai ki Apne auron ki jindgi me kya contribute Kiya.♥️🙏

[@nitinshukla914]

@@Innozant SirG, Hats Off to You 4 having such Noble Attitudes. Shat Shat Pranam ♥️🙏♥️🙏♥️🙏

[@LovlyAmit]

New thing learned today thank you sir😊

[@msexcelgooglesheet374]

hurray finally video aa gayi thanks sir ji...................

[@Innozant]

Haha..Dekhiye aur seekhiye dono method .🙏♥️

[@TheFaizanShabbir]

Thank you. I used VBA method and it worked. Thanks a lot

[@Innozant]

👍❤️

[@AbdulHamid-ci9kz]

Thanks Sir, I'm Searching this type of Methods 💝

[@Innozant]

👍

[@sonukumarskp6933]

Love you sir Aapne meri bahout badi problem solve Kar di

[@Innozant]

Thanks Sonu ji..Happy learning..Have. A great day

[@surajnarkhede3875]

Thank you very much sir for new concept of refresh apki mehant hum ranglayenge sir

[@Innozant]

👍❤️Thanks Suraj..Keep learning

[@skd0402]

I'm a fan of you every time I egerly wait of your video

[@Innozant]

Thanks Saurabh..bht mayne apke ye word mere liye dear..bht life me aap aage jayen aisa Mera wish .❤️🙏

[@skd0402]

@@Innozant thanks ji aise knowledgeable videos hame motivate karte h..

[@devendergusain8974]

I LOVE YOU SIR THNX ITS HELP ME ALOT daily learn kar rha hooon.. thnx very much sir ....

[@Innozant]

Very Good...Keep learning

[@bhaskarganguly8425]

2nd one was easy rather than 1st one..sir i learn lots of things from you..thank you..

[@Innozant]

Thanks Bhaskar 🙏❤️happy learning

[@tusharvaarunn]

I recommend you become SAP consultant... will have grt success...

[@Innozant]

I was SAP ABAP CONSULTANT 😊Left the job few years ago..
Keep exploring..Keep learning ❤️👍

[@saneeshkrishna3818]

Dear Sir,
Your classes are so amazing

[@Innozant]

Thanks Saneesh🙏🙏❤️

[@vickyaswal4582]

बहुत शानदार सर

[@gauravbanerjee7891]

अति उत्तम गुरू जी 🙏🙏🙏🙏

[@Innozant]

Thanks Gaurav Ji

[@narinderkumar7831]

kmal hai, thank you. very easy way explained.

[@santanumanna9773]

Very good approach sir. Thanks

[@tusharvaarunn]

way you explain is awsome... grt work..thanks

[@Innozant]

Thanks Tushar ji for your valuable appreciation ❤️👍

[@Nausar1]

Are waha sir maja aa gaya itna ache se explanation aur itni usefull aur advance chij thanks

[@Innozant]

Thanks

[@ask_puranik]

Super Fentabulous fantastic sir. You are taking genius sir

[@Innozant]

Thanks Prakash ji..Happy Learning dear

[@shaileshjha6623]

New to me.... ❤ Thanks a lot... appreciate

[@satishojha6240]

Really sir your are amazing and master in advance excel thanku and good night

[@Innozant]

Thanks Satish Ji..Hope Apne Kuch naya seekha aur practice bhi krte rahenge..Good Night ♥️🙏

[@sitaramkohli9549]

In VBA event​s topic is my favourite

[@Innozant]

Good ..Sita Ram Ji .Soon we start a new series ♥️🙏

[@digambarbhosale948]

We like teaching method. Smaily facee.

[@Innozant]

Thanks dear

[@SunilKumar-kn8hv]

बहुत अच्छा लगा सर

[@Innozant]

❤️🙏

[@wasimshaikh9266]

Thanks for learning us

[@Innozant]

Thanks Wasim sahab

[@2011snehatomar]

Loved it, and you are fun. you made it easy. Thank you

[@Innozant]

Thanks Sneha..God bless you dear...Happy Learning ❤️👍

[@khalidmajeed2886]

Sir---A-One,,,,,we need more and more

[@Innozant]

Thanks Khalid sahab..Sure dear ,aate rahenge videos

[@bushrarashid5860]

you are awesome sir ,thank a lot

[@pravinkumbhare1750]

Ideas cleared... Very useful... Thanx Sir..

[@bishtlokesh1297]

Very helpful trick for excel users

[@Innozant]

🙏🙏❤️

[@لاغالبَإلاالله-ح4ذ]

Sir very amazing video 👍👍👍👍👍 🎥🎥🎥🎥

[@Innozant]

Thanks dear❤️

[@gauravbhatia7987]

Good sir isi option ki wait kar raha tha sir bs app pivot power and pivot query ki series start kardo thnq sir

[@Innozant]

👍❤️😀Time ke Saath sab aayega dear..

[@basantakumarnanda2898]

Thank u very much sir for your excel videos.

[@Innozant]

Thanks Dear 🙏❤️

[@pradeepsingharora1210]

Very very helpful video
And u explained very well
Thank you very much
👍🏻

[@Innozant]

Thanks Pradeep Ji

[@ananthkumarkn2599]

Nice video sir

[@mangeshdhore]

Thank you Sir!!
This approach requires a one time effort of mapping the source file with the file having the pivot table
How can we pass the location or details of the source file having data as parameter?
With this approach all we need to do is just mention the path and pivot would get created with doing the initial configuration

[@bakbaslove]

Excellent Bhai thank you so much

[@ujjwalchakraborty8840]

Awesome video about pivot table

[@Innozant]

Thanks Ujjwal👍🙏❤️

[@RajuKumarYadav-i3t]

sir plz upload power bi class in sequence form and also provide a forward and backward skip option in your recorded live videos this will help a lot

[@Innozant]

Noted..keep learning

[@rahulcool8680]

true man, tnx. Keep up the good work bro, love u

[@Innozant]

Thanks Yusuf👍

[@lakshChait]

Thank u so much… Very helpful

[@lakshChait]

Sir, pivot table banate samay jo data pull karte h usko, As it is pull Kai Karein… kyun wahan record aane ke bajay no’s aa jate h pls help

[@muhammadasif-gw2kc]

Sir, Thank you so much for creating such knowledgeable video. I have choosen 2 VBA method. But Ctrl Z and undo doesn't work. Kindly suggest how can I do undo after Ctrl Z.

[@mukhtiarshujah5943]

Superb sir

[@NiwantGadgil]

Thank you so much sir.

[@harishpandey168]

Very nice sir....
You are great..🥰🥰

[@Innozant]

Thanks Pandey Ji..Happy Learning dear

[@harishpandey168]

@@Innozant sir mera train wala doubt hai...
Jhaan mene filter ka b filter ki baat ki thi....but smjha nhi paa rha apni problem🙄🙄

[@Innozant]

aap example query bhejna..time nikalke dekhunga..use explain kar dena kya chapte ho
[e-mail]

[@harishpandey168]

@@Innozant thank u sir...
Aapka bhut sukriya🙏🙏🙏🙏

[@kavita8390]

VBA trick was really handy and easy to remember. Waiting for your videos on VBA MACROS.
I have one question, instead of applying it to workbook , can we apply on worksheet only if our pivot table is also on same worksheet?
Thanks a lot for excellent coaching

[@Innozant]

Yes ..we can..kindly attempt and if you are facing any issue let me confirm

[@kavita8390]

Sir, thanks for reply. What shd be the code in that case activeworkbook.refreshall as that would work for entire workbook and if i enter active worksheet. Refreshall that is not an option .
Pls advise

[@DirectDilSe29]

​@@Innozant tried but its not working. Also sheet got slow even in manual refresh

[@sonu31thakur]

Thank you sir 🙏🙏🙏🙏🙏

[@Innozant]

Thanks Sonu🙏♥️Do Practice dear

[@usamalateef4765]

You're Great

[@bishtlokesh1297]

Nice ❤️

[@manoharjha509]

Namastey sir ,
Aapke dwara padhaya gya her ek lesson vakai me tremendous h for which I always will be obliged to you
Sir mere excel me ye get data me from Microsoft query ka option show nhi ho rha h

[@Innozant]

Thanks
Kaunsa version excel ka hai

[@kinghundred]

very useful sir

[@amusicaljourneybyps4403]

Sir, VBA ka complete series Bana dijiye...basic to advance level. Aur ho sake tho Python ka bhi

[@Innozant]

❤️👍

[@hsgusain2054]

Really helpful ... Thanks Sir.

[@Innozant]

Thanks dear..have a great day

[@manishnegi306]

auto refresh through vba..is amazing.

[@Innozant]

Thanks Manish Ji🙏❤️

[@saurabhgupta45]

Very nice

[@timesavertricks]

I am trying the method to create pivot table using miscrosoft query. I've already table made
but after following all steps as guided by you in video
and i click finish it doesn't uploads the data
as well as I've approx. 8-10 columns only
but it's showing me 100's of column
there are columns present as i named
but apart from that it also shows me column named as f1 till f200 on so on

[@SreejeeBhattacharyya]

Your videos are very good and easy to understand .... thank you sir :) PLEASE KEEP MAKING SUCH GREAT VIDEOS SIR :) GOD BLESS ...HAPPY NEW YEAR :)

[@Innozant]

Thanks Sreeja for your valuable appreciation.Have a wonderful career ahead.

[@SreejeeBhattacharyya]

@@Innozant ❤️

[@DailyVlog-iz9ny]

Sir Pivot table and simple table mein data validation ka method same hai ya different

[@devendergusain8974]

YES SIR VALUE ADDING IN MY LIFE

[@Innozant]

🙏🙏🙏🙏

[@kuntalganguly7729]

Sir, vba ka v learning video suru se doge to bahut help hoga.

[@Innozant]

Krenge jald

[@prashantgupta2172]

Bhai vba series laao aap

[@Innozant]

Prashant Ji VBA se pehle Power series start karnege Kuch din baad bus Excel ke majn concept pehle finish kar Lein.🙏♥️

[@kumarsingh8617]

Sir Really admire U, We have learnt so many thing in Excel by your video...Thank you so much Sir, Please updated more video related to VBA .

[@Innozant]

Thanks Singh Sahab.
Yes dear will upload VBA and bi series

[@BPOCODER]

Sir can you please make more videos on VBA in mis

[@rajansaini3886]

Very useful👍

[@anilvijayvargiya2101]

I liked it videos and also helping me in my work. While applying auto refresh code it works very well. But when we delete entire source data and updating new sources data in pivot table ROW options get also removed and need to rearrange. Which is I think minuse point of Auto refresh

[@kewal229]

Yes.. also when you add ane new row below, if it is the absolutely new text or field, then in pivot table the format will not continued.. (Bold, font style, alignment)

[@kewal229]

One major drawback of auto refresh is: it's automatically saving the workbook.. You can't undo the last changes.. 🤭

[@SarfarazBAG]

bhai trick acha tha but kya ye data range ko b refresh karta hain?

[@banidas6703]

excellent

[@pradippandey9841]

nice sir thanks a

[@Innozant]

Thanks dear

[@ShabbirKhan-pq8iq]

Lajawab ..

[@syedumai8315]

Asalam o alecom sir ap cube ka formula bhi btay WO mujhay lazmi sikhna hay

[@artiverma2357]

beautiful sir

[@Innozant]

Thanks Arti..Good Night 👍❤️

[@mamunhossain6706]

Thank you

[@gaming666all]

Sir ye sheet drive E Wale data pr hi work kerti hai kya

[@tejpalsain1507]

Great sir. Thanks

[@Innozant]

Thanks Tejpal♥️🙏

[@kishorpanara4191]

Nice sir I like

[@Innozant]

❤️🙏

[@sureshgautam7441]

V nice

[@HabibUllah-cw7do]

I tried the 2nd method, I also saved the file microenabled, however the funtion to Undo an action (Ctr+z) is not working afterwards
Any suggestions?

[@mujahidpasha198]

Thank u sir

[@narendratodarwal1176]

Sir mujhe product catalogue banani he which is having images of products through pivot table, can it be possible?

[@gamesworld_all]

Thank you sir

[@gamesworld_all]

sir, Is this comes under VBA?

[@Innozant]

No dear,Tabhi excel se BHI auto refresh bataya aur VBA se bhi

[@gamesworld_all]

Please start VBA series sir

[@Innozant]

VBA se pehle Power bi series dear..wo jyada in demand hai

[@gamesworld_all]

@@Innozant not vbs sir, VBA visual basic application

[@shivamrana9651]

will this method work with large data

[@abhi4k2009]

After adding the VBA code, the "Undo" (Control Z) doesn't work. Is there any way to add this VBA code and Undo option also works?

[@AYANDEV09]

Sir i can't find "From Microsoft Query" option in Office 2021. please help me sir

[@sumantabhuin7433]

Sir, can we make the first option user independent? I mean let's say I make one dashboard with the first option and i want another user to update in the source sheet in his system and it got updated in the dashboard automatically

[@kankankalitachhaygaon7533]

New data add karnese bhi auto refresh hoga ki Nehi...

[@vijaysen677]

Sir I am using excel 2016 but View code option not showing so could you please help here

[@aritramech]

Is there any way to refresh a pivot table report without opening the file? I’ve made several reports using power query and power pivot but it takes a lot of time every time I refresh the data .
Thanks in advance 🎉

[@shaileshjha6623]

Do you provide any paid series of classes of excel, vba and PBI for professional having almost good level of basic excel.....as i was going through your entire pivot table series and got 2-3 good tips that i was not aware of earlier although i have 6 years of working experience in the field of fp&a, valuation, m&a and mis post qualification of CA.

[@Innozant]

Yes .You may visit Innozant website for more details about upcoming batches and courses or connect with Team Innozant for more queries

[@shaileshjha6623]

Thanks and really appreciate for prompt response 😊

[@rjraviraftarup7553]

Koi problem nahi hai sir

[@Innozant]

👍

[@amitpandya7712]

very nicely explained but sir one issue is there that in case we add additional column then this auto refresh pivot table is not working. do you have any solution for this sir ???

[@Innozant]

Kindly check another video of pivotbtable refresh using offset function to make dynamic range .

[@raj5455]

Please make video with sumifs & indirect combination

[@Innozant]

Dear abhi maine indirect convey padhaya nhi hai...Choose topic is about to finish after that we will start Indirect complete concept..Bus thora sa wait kijiye Jo aap chahenge wo concept ke video apke paas honge.🙏♥️

[@raj5455]

@@Innozant thanks. Your videos are very much useful for us. Also request you to explain vba & macro topic in future.

[@Innozant]

Sure dear soon...