how do I make Pivot table update automatiocally when I change values

I have a Graph thats based on a pivot table
I need the pivot table to update when I change a value in one of the cells that changes all the results of the formulas involved

Originally Posted by pjoaquin

To update the pivot table values when you change your data, simply click the red exclamation point icon on the Pivot Table toolbar (View > Toolbars > PivotTable).

The PivotTable must be active for the toolbar to be active.

any way to refresh data that has filters on it so if values change then the data resorts itself in the filtered cells??

As far as I know, the only way to make it automatically update is to use a VBA script.

Originally Posted by wanax

As far as I know, the only way to make it automatically update is to use a VBA script.

anybody have a VBA script for this???
I need it to auto upadate...most of my end users will not get going to the pivot table and refreshing data..especially when I would like to hide the pivot table