View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Create refresh button in worksheet to refresh Pivot Table Data

I've created a sourc e data worksheet, that kicks out to a pivot table in
same workbook. I want to add button to the sheet where the user would just
have to select it, to refresh data. Just trying to make it easy for those
that may not have their pivot table bar up, or forget to click in chart to
bring up refresh button.

Any ideas