You can create a macro button to refresh your pivot table instead of using right click of your mouse. Watch the video using below link to learn the steps.
​Refresh pivot macro​​​


​Homepage​​​
​MS EXCEL TRAINING​​​