Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,979
Default Create refresh button in worksheet to refresh Pivot Table Data

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.

Ron wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
refresh a new worsheet on pivot table refresh [email protected] Excel Worksheet Functions 0 February 9th 07 08:39 PM
Refresh Data Pivot Table Annabel Excel Discussion (Misc queries) 0 October 3rd 06 09:00 AM
Pivot table Data refresh SSD1 Excel Worksheet Functions 2 June 17th 05 09:13 PM
how to create button commande to refresh data in query in excel 2. Jean-Francois Excel Discussion (Misc queries) 1 January 6th 05 09:03 PM
Pivot Table Data Refresh patemarie Excel Discussion (Misc queries) 1 December 1st 04 05:35 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"