Auto Update Pivot Tables

[richiebkerry]

Hello, I have two pivot tables (called "PivotTable1" and "PivotTable2") on two tabs ("usage" and "cost").

I input data on a tab called "INPUT" and would like it so that when new data is added the pivots for all the worksheet automatically update.

I have saved the file as macro enabled and followed Google steps but I just can't get it to work! Any help would be greatly appreciated.

Thanks

Rich

 

[Surreybloke]

I've looked into this before. Other than specific VBA code to deal with the issue, the general advice is to set up your data as a table, or to have a dynamic range. This will then set-up the pivot to automatically refresh.

There is a tick box you can click on within the pivot table by right-clicking that sets it to automatically refresh each time you open the file, but that obviously doesn't completely cover it for the solution you're after.