Auto refresh pivot table on internal data change

Question

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.

TIA

Solution

a. How do I insure of an automatic update?

I don't think this is possible when your pivot source is in the same workbook. For external data sources you can set to refresh every x minutes.

b. How do I manually refresh the pivot table to use the latest data?

When the active cell is within a pivot table, you will have the Refresh option available under PivotTable Tools | Options on the Ribbon bar.