Refreshing Pivot Chart Range

[tjgrassi]

I'm looking for a way to refresh my pivotchart and update my pivot table data every time that a certain macro runs. I could just delete it and make a new one everytime but that runs in to the problem of defining a new sheet every time. Is there a simple way to do this. say I my pivot chart is on "Sheet 7" and it there is only one pivot chart in the workbook and my source sheet is on "Combined Data". and at the moment the data range is "A1:N435" and say next time I run my macro the data range will add 20 rows of data and the next 25.

[stephenloky]

Put your source data into a "Table" and make the "Data Source" of the pivot appoint to the "Table" you set in first step. Should work fine.