| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
97 to 2000 Refresh pivot table
I wrote code for a button that refreshes a pivottable on click. When I try to click the button using 97 I get a Run Time Error. Can someone please tell me how to use the Activesheet.RefreshPivotTable code so that it works in both 2000 & 97
Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
97 to 2000 Refresh pivot table
Set the command button's TakeFocusOnClick to False, or add the following
line at the beginning of the code: ActiveCell.Select Deeds wrote: I wrote code for a button that refreshes a pivottable on click. When I try to click the button using 97 I get a Run Time Error. Can someone please tell me how to use the Activesheet.RefreshPivotTable code so that it works in both 2000 & 97 Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| slow document / pivot table refresh and pivot function | Excel Discussion (Misc queries) | |||
| Pivot table refresh | 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 | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Linear Mode
