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

@theofficelab

4 жыл бұрын

Happy to hear that! 😊

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.

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

Best tutorial ever for making dashboards using excel.

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

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

Excellent series of videos, have really learnt alot

You are the best one

Keep it up, I love your tutorials. :)

@theofficelab

3 жыл бұрын

Thanks a lot! I am happy you like them 😊

Simply amazing

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

Thanks Sir

Check out my new website excelfind.com for the Free Version of the Dashboard 🚀 ⬇ FULL TUTORIAL SERIES PLAYLIST [Ep. 1] Basic Dashboard ► kzread.info/dash/bejne/lX-futayms_LiJc.html [Ep. 2] Background & Tile Design ► kzread.info/dash/bejne/gJp506Wdls-YY84.html [Ep. 3] Modern Slicer Design ► kzread.info/dash/bejne/dZZ4tqifn8i2irw.html [Ep. 4] Auto-Refresh Pivot Charts ► kzread.info/dash/bejne/ipilmbV-Xd2Tcdo.html [Ep. 5] Interactive Info Button ► kzread.info/dash/bejne/hI6Lj9iKgtWWnrw.html [Ep. 6] Interactive Dashboard Tabs ► kzread.info/dash/bejne/ZKWCl8yOma29fbw.html [Ep. 7] Interactive Settings Menu ► kzread.info/dash/bejne/mHd6qdOjZLTJerg.html

simple and effective. nice.

@theofficelab

4 жыл бұрын

Thank you, Sir 😊 I am glad you like it!

Simply superb

@theofficelab

4 жыл бұрын

Thanks, Bro 😊

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!

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

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?

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.

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.

@theofficelab

4 жыл бұрын

Hi Gustavo, thanks for your fantastic feedback 😊 Regarding your question, you didn't do anything wrong. That's a general issue coming with macros. Once a macro/ VBA code has been executed, the Undo Stack (where all the previous actions are stored) is reset. That is something many people hope Microsoft will change in the future.

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.

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?

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

@theofficelab

4 жыл бұрын

Hi Sir, I understand and I am sorry for the wait. The remaining tutorials for the tabs and the settings area will be coming within the next two weeks. It takes some time to produce these videos, especially the settings area video is a huge tutorial and I want to ensure the quality of it. I hope for your understanding. It will be worth the wait 😊

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?

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?

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?

@theofficelab

4 жыл бұрын

Thank you, Sir 😊 Regarding the message box: That's just the Mac OS native look of these popup windows. Doesn't have much to do with Excel itself.

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

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

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?

@theofficelab

4 жыл бұрын

Hi Juan. Thanks for your question 😊 The key is to put your source data into a table and, when creating the pivot tables, reference this table (via its name) instead of the cell range. Because then, once you add new data below your existing data, this data will be automatically included into the table and if you have an auto-refresh VBA script in place the pivot tables and pivot charts should display the additional data instantly.

@JuanCruz-qd1tw

4 жыл бұрын

@@theofficelab Great! Thanks for the reply! Your videos are amazing

@theofficelab

4 жыл бұрын

@@JuanCruz-qd1tw Thank you 😊

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?

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

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

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

Fehler beim Kompilieren: Variable nicht definiert If I define the variable then it works: => Dim pc as Variant I have recognized this in other tutorials on youtube. Why do I have to define the variable, but you and others don't need to and it works properly??

@dom139

4 жыл бұрын

If you have "Option Explicit" enabled then you must define a variable before using it within your code. Without "Option Explicit" any undefined variables are defined as Variant by default.

@schtefel

4 жыл бұрын

@@dom139 thank you very much, super helpful. Now I finally know what "Option Explicit" means. It always pops up automatically when I open a new module for instance.

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

@akhileshravikumar6910

3 жыл бұрын

Thanks you so much for this piece of code!

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?

@theofficelab

4 жыл бұрын

Hi Diego, have a look here: stackoverflow.com/questions/38246393/vba-pivot-table-collapse-all-fields You could apply that to your specific pivot table or include it into the Refresh script shown in this video. Hope that helps 😊

@LifeByDiego

4 жыл бұрын

@@theofficelab worked like a charm! you're the best! thank you :)

@theofficelab

4 жыл бұрын

@@LifeByDiego My pleasure! Glad it worked 😊

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

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

@theofficelab

4 жыл бұрын

Hi Ritesh Raj, the tutorials on tab buttons and the complete settings menu will be coming within the next two weeks. It will be worth the wait 😊

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

@theofficelab

4 жыл бұрын

Hi there 😊 That's another Tutorial about the Settings Menu that will be coming in less than two weeks.

@OfficialMoin

4 жыл бұрын

​@@theofficelab That's great but can you help me with a complex formula in Excel?

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

@theofficelab

3 жыл бұрын

Excel 365 (with an Office 365 subscription). This demo is on Mac, but it works on both OS.

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

@theofficelab

4 жыл бұрын

That should be covered by the script. As long as you have your data in a table, a new data entry will automatically be included in the table and, thus, also in the refreshed pivot table.