97 to 2000 Refresh pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Set the command button's TakeFocusOnClick to False, or add the following
line at the beginning of the code:

ActiveCell.Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables not refreshing after data source update 1
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
refresh multiple pivot tables in workbook 2
Pivot Table Refreshing 2
Auto Refresh Pivot Table after Source Data is Refreshed 0
omit dialog box display during pivot table refresh (macro) 4
Pivottable refresh problem 1
Wait till pivot finishes refreshing 1

Back
Top