August 29, 2008 06:46pm pdt

1. zorvek 2,107,186
2. rorya 2,046,988
3. saurabh726 1,301,130
4. chris_bot... 776,246
5. byundt 680,182
6. nutsch 546,068
7. patrickab 412,280
8. jeverist 407,238
9. spattewar 316,278
10. matthews... 303,769
11. ahammar 281,891
12. webtubbs 256,684
13. jpaulino 245,997
14. RobSamp... 240,914
15. dj88 210,941
16. irudyk 163,728
17. WJReid 150,302
18. weellio 143,519
19. Psychotec 133,785
20. epaclm 119,855
21. GrahamSkan 107,769
22. jell 100,971
23. Merch_Ops 92,593
24. gtgloner 83,427
25. StellanRo... 80,929

1. zorvek 9,411,677
2. byundt 7,423,271
3. rorya 5,741,719
4. matthews... 2,866,897
5. jeverist 2,817,507
6. patrickab 2,167,843
7. roos01 1,919,714
8. mvidas 1,529,753
9. saurabh726 1,394,709
10. webtubbs 1,353,076
11. fanpages 1,234,722
12. brettdj 1,095,751
13. MalicUK 1,059,396
14. chris_bot... 965,752
15. mgh_mgh... 649,110
16. LoNeRaV... 602,049
17. ahammar 582,024
18. ture 570,551
19. nutsch 546,068
20. spattewar 525,227
21. R_Rajesh 468,975
22. jpaulino 358,896
23. david251 355,614
24. RobSamp... 339,463
25. sebastienm 339,407

06.27.2008 at 03:43AM PDT, ID: 23521115

	[x] Attachment Details

Code to make all pivot tables in a workbook independant?

Asked by Merch_Ops in Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2003

Hi - I've got some code that loops through all the pivot tables (20 or so) in a workbook and refreshes them. Unfortunately many of these were copied from others in the workbook. So refreshing each of those pivot tables refreshes all the copied ones. Basically it takes ages to run as some PTs are refreshed multiple times.

Is there any way to loop through them and set them all as independent?

Cheers,
Alastair.Start Free Trial

Keywords: Code to make all pivot tables in a work…

	Title
1	Pivot tables: updating the row field se…
2	Pivot table data range within workbook…
3	Pivot Tables
4	Getting Pivot Table to Automatically Filt…
5	Format Date On Pivot Chart
6	Format Pivot Chart

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Code to make all pivot tables in a workbook independant?

Asked by Merch_Ops in Microsoft Excel Spreadsheet Software

Tags: Microsoft, Excel, 2003

About this solution