Auto Refresh Pivot Chart

[cyliyu]

I have a Pivot Chart created in the same sheets.
I want the chart to be auto-updated each time the data is updated.

Tried

Please Login or Register  to view this content.

and it works but all other worksheet in the same workbook will be updated too.

What should be the VBA code to have only a particular Pivot Chart auto refresh?

[:) Sixthsense :)]

Refresh the pivot so that chart will get refreshed.

[cyliyu]

How can I have the pivot auto refreshed using VBA?

[:) Sixthsense :)]

https://www.techonthenet.com/excel/m...refresh_pt.php

[cyliyu]

I have this VBA code in the module:

Please Login or Register  to view this content.

When the search button was clicked, the Excel data will be updated and the Pivot Chart created using this data range will auto-updated as well.
But "ThisWorkbook.RefreshAll" will update my other Pivot Chart in other sheets which I want to avoid.

[:) Sixthsense :)]

Replace thisworkbook.refreshall code with the below

Please Login or Register  to view this content.

Change the sheet name and Pivot Table name accordingly.

[cyliyu]

Thanks.
If I am not wrong, this code only applied if you have both the data and pivot chart in different sheets and it won't work if both in the same sheet.

[:) Sixthsense :)]

It works wherever it is... The thing is that you have to mention your pivot table name in that code.

[cyliyu]

Ok.let me try again as I am seeing error message

Please Login or Register  to view this content.

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[cyliyu]

I keep getting the error message.
My pivot chart name - PivotTable2
Sheet name - sPCE

Capture.JPG

[cyliyu]

Please refer to the sample file, I want the chart automatic update as well when the search button clicked.
Can anyone help? Thanks in advance.