-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
pivot table code update
-
C
Update Pivot Table and Enable Outlining on Open returns Runtime Error
Good Day, I am very new to vba and am trying to make this work. I have a workbook with more than 20 sheets. Each one of them has a pivot table with a source in an external workbook and each one of them has an outline that allows group/ungroup a set of rows. I need all the pivot tables to be...- cesardltr
- Thread
- Replies: 1
- Forum: Excel Questions
-
M
VB script for selecting same name in multiple pivot tables
Hello, this is my first post to this forum, and I would appreciate some help. <o:p></o:p> I am trying to write some VB script that selects the same name in 2 separate pivot tables. <o:p></o:p> I have a pick list of names, and when I select a name off that list, I then want the 2 separate pivot...- Mew22
- Thread
- Replies: 5
- Forum: Excel Questions
-
Pivot Table & VBA Code
I am using following code to update the pivot tables in another worksheet, when I select a worksheet. I have about 7 Pivot Tables that use the same source data. It takes a little while to update all 7 pivot tables after I select the sheet. Is it possible to make the update much faster? Privatse...- kishorkhanal
- Thread
- Replies: 8
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 44
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...