| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Pivot
Hi,
Can anyone help me?! In an earlier post I found a solution how to write a VBA to automatically refresh a pivottable. However I have a small problem re3garding the 'define name' because my source data is situated somewhere from A8 to K...(x). How should rewrite the formula in order to make my VBA work agian? ='2. Template nummerlijst'!$A$8:(INDEX('2. Template nummerlijst'!$8:$65536;COUNTA('2. Template nummerlijst'!$A:$A);COUNTA('2. Template nummerlijst'!$8:$8)) Btw; It's not US/English i.e. the ';' where normallly 'a' , would be Already many thanks Basta |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Threaded Mode
