Sign in to follow this  
Followers 0
Pachan

Refresh of Excel sheet pivot table

2 posts in this topic

Hi Team,

Please let me whether there is any Excel Function which will do refresh of pivot table.Since "Save" is not refreshing the pivot table, I am closing and opening the XL file to achieve refresh. Is there any better way of achieving that, if we don't have a XL function.

Thanks,

Thomas

Share this post


Link to post
Share on other sites



$oExcel.ActiveSheet.PivotTables ("PivotTable5" ).PivotCache.Refresh

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0