Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4

on adding macro code to refresh the workbook and inserting a new data, it ungroups the columns used in the pivot table. do you know how to fix this issue?

You are the best one

This is great information and I see the code works.. but only to update the information already there. Could you also describe how to automatically add new points in the pivot chart? For example, you have January thru July on your data sheet. If you add August, or November... how can I make those new points add into the current chart? Thank you for a good lesson.

After applying the first code , while entering new data the undo option is not working . Please help

Best tutorial ever for making dashboards using excel.

Is there a way to select other sheet after running the code from this video?

I had no idea this was possible. Thanks for sharing these tips!

Simply amazing

Do I have to write this code every-time as after closing the file and again opening this code is not there anymore. ??

This is great, thanks for sharing! One question. For some reason when I delete the old data and paste in the updated information I lose all formatting in the dashboard. Is there a way to avoid having to redo it each time?

thanks. I got a runtime error. I think its because I have a slicer on a different sheet than the source data. This VBA works if I locate the code on the source data sheet. But I want the update to occur when the slicer is changed on another sheet. When I add the code on this sheet, I get the error. I have a keyboard macro "refreshall" that works but refreshall from VBA gives a runtime error. Any suggestions?

How to refresh pivot table and chart if the source data is coming from another xlsx file..? Appreciate if you could help me.

Part 4 seems to have a lot already done. I thought we'd be continuing from where we left off in part 3

Is there a way that I can call a sub procedure every time a slicer is used?

Hi! How did you change the color of the Multi Select and the Clear Filter? I already run through to all of the training but I can't seem to find the part where you also change the colors of it. But really thanks for all these videos, You're amazing in every way! Keep up!

Cool

Excellent series of videos, have really learnt alot

Keep it up, I love your tutorials. :)

Never knew that my life needed something like this...

FYI if you have your Pivot Table and Source Data on the same page you will have to use this:

Application.EnableEvents = False
ThisWorkbook.RefreshAll
Application.EnableEvents = True

which version of Excel is that? is it on Windows?

This is very helpful. I learned a lot from your videos. Looking forward for your uploads in the future.

It is not working for whatever reason. I have functions to draw the data from other sources in this tab. Is this perhaps the issue?

What about when there is a new data entry in the table?

Hello! ran into a bit of a problem after auto refreshing, one of my pivot tables has subgroups and every time i insert new data into my table, the pivot chart expands completely and i need it to be collapsed. is there a script to auto collapse all tables in a sheet once data refreshes?

How would you be able to make Option 2 work when there are 2 data sheets? I am running into this problem. I went into both data sheets and used the refreshall code, but only one will work, or not work at all.

You really are a natural teacher. Calm, well presented, and great content. Learned a lot already

Amazing video. Very very informative. I will try to record a macro and find out what is going to be different from your code.

Cool. It works!!! Thanks for the tutorial! 😊

Very Informative and amazing video series.
Thank you for taking time and making such videos.
It is really exciting and I am in love with Microsoft Excel now.

Hi Sir. If data is added frequently, then the pivot chart would become crowded. How to make a limit or date range in the chart?

Great video! Thank you very much. I got one question. What if you want to add data to the file instead of changing existing data? How do you make sure the pivot tables refresh automatically when you add this new data, and how do you make the pivot tables actually "grab" this new range of data?

Fantastic presentation. I have been following your channel for the last 2 weeks and I have learned so much. Great job. I have just one question, I have office for Mac 2019, when I did the VBA (the first option), the "Undo" and "Redo" function of excel was deactivated. Since I am very new to this, just checking to see if I did something wrong. Your work is phenomenal and thanks for putting the effort and time to make such a hight quality videos.

What about the settings icon in the left corner, how to add that?

Sir but when you will upload the video regarding Ribbon Buttons and how to apply different themes

Thanks Sir

Awsome..but I wish you could show your final version in today's episode itself , I m waiting since days

Simply superb

simple and effective. nice.

Awesome work! On a side note - your message boxes have a different look and animation from MS's stock software. How did you do that?