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
and it works but all other worksheet in the same workbook will be updated too.
Please Login or Register to view this content.
What should be the VBA code to have only a particular Pivot Chart auto refresh?
Refresh the pivot so that chart will get refreshed.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
How can I have the pivot auto refreshed using VBA?
I have this VBA code in the module:
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.Please Login or Register to view this content.
But "ThisWorkbook.RefreshAll" will update my other Pivot Chart in other sheets which I want to avoid.
Replace thisworkbook.refreshall code with the below
Change the sheet name and Pivot Table name accordingly.Please Login or Register to view this content.
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.
It works wherever it is... The thing is that you have to mention your pivot table name in that code.
Ok.let me try again as I am seeing error message
Please Login or Register to view this content.
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
I keep getting the error message.
My pivot chart name - PivotTable2
Sheet name - sPCE
Capture.JPG
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks