Create refresh button in worksheet to refresh Pivot Table Data

[Guest]

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

 

[Debra Dalgleish]

You can record a macro as you refresh the pivot table.
Then, from the Forms toolbar, add a button to the worksheet, and assign
your macro to that button.