If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA for updating Pivot Tables

Thread starter kleinsim
Start date Jul 4, 2008
Tags

office cube pivot tables update vba

kleinsim

New Member

Jul 4, 2008

Hello everyone,

I have a question regarding VBA and pivot tables. I have a worksheet with several outputs of scenarios that I am running. I would like to create a worksheet that lets you compare scenarios. To analyze a scenario I need to create a pivot table hence my question is what the VBA code for a button would be to change the source data of a pivot table, to update the Office Cube, and to recalculate all the cells in the worksheet. I know how to put VBA into a worksheet but I currently do not know how to write the code yet. Hopefully someone can post the code here...

Thanks!

kleinsim