I've a worksheet that has some data (sheet1) and another worksheet that has a pivot table(sheet2).
How do I make sure that when I update the data in sheet1 the sheet2 pivot table is updated?
a. How do I insure of an automatic update, or failing which
b. How do I manually refresh the pivot table to use the latest data
What I do know is that I can select 'Refresh data when opening the file' but I don't want to open and close the file.