Pachan Posted July 14, 2010 Share Posted July 14, 2010 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 Link to comment Share on other sites More sharing options...
Juvigy Posted July 14, 2010 Share Posted July 14, 2010 $oExcel.ActiveSheet.PivotTables ("PivotTable5" ).PivotCache.Refresh Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now