Pivot Table - Refresh

[brandedadnan]

Dear All,

I have created a pivot table and it has a large amount of data. When i go back and refresh data it get hanged. it also get hanged when i change the data source.

The file is too big and confidential to be shared online.
Can you please provide me with any method.

Regards
Adnan

[Mikeroku]

Hi Adnan,

You may try the below auto range selection in your macro.it will fix the problem.



ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _
SourceData:=Range("A1").CurrentRegion.Address, Version:=6).CreatePivotTable _
TableDestination:="", TableName:="PivotTable1", DefaultVersion:=6
ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1)

[brandedadnan]

Thanks... Got it