I want to refresh my existing pivot table in excel in VB
.net Application when i refresh my Base data.How can i achieve that.
How can i use PivotTableWizard for this purpose?
With this,I have formula attach with this base data so when my base data get refresh the reference data also get refresh,problem is when my base data has more rows than that formula not carry forward to that extra rows..How can i resolve this issue using VB
I already achieved refreshing my base data but stuck on Pivot refresh and formula carry forward..Anyhelp is higly appreciated.