Hello, this is about a quick shortcut with respect to refreshing pivot table. When you right click on any pivot table, and if you go to pivot table options, within one of the tabs which says data tab, there's an option which says refresh data when opening the file. Now, if you are expecting that a lot of data inside the source data is going to get updated or getting revised every now and then, then you perhaps would be better off if you keep this option chosen refresh data when opening the file, which means you don't have to say right click and refresh every time you are seeing a change in data set. So there you go. small trick on the option side