Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4
82,331
Published 2020-02-26
📌 EXCEL VERSION: Microsoft Office 365 - Get it here ► geni.us/Office365_Microsoft
▬▬▬▬▬▬▬▬▬▬
🔥BIG NEWS ► Launch of excelfind.com/ 🔥
I just launched my new Excel Resource Website and kindly invite you to check it out.
I put a lot of work and research into it to provide you with the biggest possible value!
Main Website ► excelfind.com/
Recommended Courses ► excelfind.com/courses
Tutorials ► excelfind.com/tutorials
Most Powerful Excel Add-ins ► excelfind.com/add-ins
And even better, I integrated the most up-to-date databases about all relevant functions, formulas, and shortcuts. You can use our advanced filtering system to filter by Relevance, Category and even minimum required Microsoft Office Version. That means you can learn about all new functions in Microsoft Office 365 with only one click!
Excel Functions ► excelfind.com/excel-functions
Excel Shortcuts ► excelfind.com/excel-shortcuts
If you like that website and want to help me grow, please consider to share it online and with everyone you know.
Thanks for your support!
▬▬▬▬▬▬▬▬▬▬
Auto-Refresh Pivot Tables and Pivot Charts when Source Data Changes | Ultimate Excel Dashboard Ep. 4
In this Excel Tutorial you will learn how to make the Pivot Tables and Pivot Charts in Excel automatically refresh when the source data changes. This is a powerful solution for any dashboard application with regular data updates, because it eliminates the need to manually click the Pivot Table refresh button every time the source data updates and ensures that every dashboard user only works on up-to-date and not outdated data.
The previous three episodes we covered how to build the basic interactive Excel dashboard and had a detailed look into advanced background, gradient tile and pivot slicer designs. The following Episodes will go deeper into the creation and integration of truly advanced features like fully functional info buttons, in-tale tab functionality and a collapsable settings area with state-of-the-art radio buttons for dashboard color theme selection and modern toggle buttons to control the visibility of specific dashboard elements.
If you want to build this dashboard yourself, we recommend to upgrade your Excel Version to the latest one which is included in the Microsoft Office 365 Subscription. Find the link for current offers in the Microsoft Store below ↓
▬▬▬▬▬▬▬▬▬▬
You want to become a master in Excel and learn all modern and relevant Excel techniques?
Then definitely have a look at the following links.
🚀 OUR EXCEL RESOURCE WEBSITE ► excelfind.com
💎 RECOMMENDED ONLINE EXCEL COURSES
GoSkills is our favourite & it’s not even close. Have a look ► bit.ly/30PWMnQ
📌 EXCEL VERSION IN THIS VIDEO
We use the latest version of Excel via the Microsoft Office 365 subscription. This allows us to have all the latest features like new chart types, a huge integrated icon library, improved functions, and much more!
If you want to upgrade your version as well, we recommend to get it from the
Office 365 (subscription based) ► geni.us/Office365_Microsoft
Office 2019 (standalone version) ► geni.us/Office2019_Microsoft
▬▬▬▬▬▬▬▬▬▬
You want to show your support and help me grow?
Here is what you can do.
🚀 SHARE MY NEW EXCEL WEBSITE ► excelfind.com
☕ WANT TO MAKE MY DAY?
Buy me a Coffee ► bit.ly/2Oqg6Cu
🔥 MORE AWESOME EXCEL AND POWERPOINT CONTENT
Subscribe ► bit.ly/37bcvAB
Note: Some of the links in this description are affiliate links, meaning, at no additional cost to you, we will earn a commission if you click through and make a purchase. This supports the channel and allows us to continue to produce videos like this. Thank you for your support!
#interactive #excel #dashboard
All Comments (21)
-
You really are a natural teacher. Calm, well presented, and great content. Learned a lot already
-
Check out my new website excelfind.com/ for the Free Version of the Dashboard 🚀 ⬇ FULL TUTORIAL SERIES PLAYLIST [Ep. 1] Basic Dashboard ► https://youtu.be/cKkXtyjleX4 [Ep. 2] Background & Tile Design ► https://youtu.be/NfEqCdfl23k [Ep. 3] Modern Slicer Design ► https://youtu.be/CbDTFfoePZY [Ep. 4] Auto-Refresh Pivot Charts ► youtu.be/Xdq7SE-z-Aw [Ep. 5] Interactive Info Button ► https://youtu.be/RZW-vQRr0nY [Ep. 6] Interactive Dashboard Tabs ► https://youtu.be/2qN5jUiJWMY [Ep. 7] Interactive Settings Menu ► https://youtu.be/fCFGqj4QcJU
-
Never knew that my life needed something like this...
-
Best tutorial ever for making dashboards using excel.
-
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.
-
This is very helpful. I learned a lot from your videos. Looking forward for your uploads in the future.
-
I had no idea this was possible. Thanks for sharing these tips!
-
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!
-
Amazing video. Very very informative. I will try to record a macro and find out what is going to be different from your code.
-
Excellent series of videos, have really learnt alot
-
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?
-
Cool. It works!!! Thanks for the tutorial! 😊
-
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.
-
Keep it up, I love your tutorials. :)
-
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.
-
Hi first of all thanks for the content. If the dashboard and the source data are on different excel files, is it still possible to do this? If so, how would one go about doing that?
-
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?
-
Simply amazing
-
simple and effective. nice.
