update pivottable

Hi all! I have a workbook that contains a pivot table, a data set, and several user input pages. I have a macro that updates this data set, and the size of the set may change between each update based on user inputs elsewhere in the workbook. I would like the Pivot Table to update as well...

I have a dilemma that I'm faced with. I have 30 slicers(3 each for 10 different sets of pivot tables). I need to update all of the slicers based on the user selecting from a single set of slicers(all of the slicers have the same info from different days). I have it set up to do this via...

Good morning, Any idea why this code keeps giving me an error?? Private Sub Worksheet_Activate() Sheets("PT Obj. e Ind.").PivotTables("PT_Obj_e_Ind").RefreshTable End Sub Thanks!!

I have had posted a similar issue earlier, but it did not solve my problem. Therefore, I try again. My Pivot table gets data from a OLAP Cube. Using the macrorecorder i got this code by setting a new date in the filter and then update the Pivot table. I can manually change the date and it will...

I have multiple pivot tables on a worksheet and I want it to update the values based on a value in another cell. I am planning on creating over a 100 tabs so I would like a macro that would make the pivot table reference the cell in that specific worksheet it is located. Any help is appreciated.

Hi, I have a pivot table that I need to update quarterly. The values are "Sum of 20134 DEC", "Sum of 20134 WAGES", and "Sum of 20134 EST". When I receive the new quarter's data, I don't want to create a new pivot table, but just refresh/ update the fields mentioned above. I have set the...

Hello I have an issue that i have been playing around with my self for quite sometime now. I found a code that should work but for some reason it is not working and I haven't a clue why. Any help would be appreciated. Goal : Code that will take a drop list and modify the pivot filters on...

Hey Guys I have a report that I put together monthly. The report contains 38 different pivot tables all of which reference a single separate excel workbook. I would like to write a VBA macro that changes the data source for all 38 Pivot Tables to a new excel workbook and updates each pivot...