Advice on Pivot Tables

[PeterG]

Hi All,

I have just managed to figure out how to setup a pivot table. M
question is, now that I have managed that, how can I get the pivo
table to automatically update when i change any data within the mai
table.

Peter

 

[Myrna Larson]

You would have to write a VBA Worksheet_Change event macro.

Doesn't the Pivot Table toolbar activate when you click on a cell inside the
table? It should. There's a button on that toolbar to refresh the table.

 

[PeterG]

Hi Myrna,

I tried changing my information, then click on a cell in the pivo
table, nothing happens.

Can you suggest what is not working or setup.
Also, do you have an idea what the VBA Change bit would look like.

Ta,

Peter

 

[Myrna Larson]

After you click on a cell within the table, you must click the REFRESH button
on the Pivot Table Toolbar. It looks like a burgundy exclamation point.