One of my worksheets has about 40 pivot tables. I know that there is a pivot table option to "refresh tables when opening file". But my raw data can be amended any minute and I do not want to close and open the file to refresh all of the pivot tables (is that what the pivot table option means?).
I just wondered if I could have a macro to refresh all of the pivot tables in one go whenever I want to?