LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default DYNAMICALLY data source for pivot table

is there any way to change datasource dynamically

Example.

I will three Command Button, each button refer to three data source

Button A - Production
Button B - Development
Button C - QA

based on click, pivot table will change the data source, if i press refresh
i will populate corresponding data

thanks

 
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
Pivot table data source gordonrss Excel Discussion (Misc queries) 0 February 11th 09 03:08 PM
how do i link to a pivot table to get data dynamically Michael001 Excel Worksheet Functions 2 February 23rd 06 10:23 AM
Pivot Table data source thunderbirds Excel Worksheet Functions 4 December 22nd 05 04:51 PM
Pivot Table data source "data source contains no visible tables" Jane Excel Worksheet Functions 0 September 29th 05 08:28 PM
Pivot Table Data source Shashi Bhosale Excel Programming 0 September 8th 03 06:32 PM


All times are GMT +1. The time now is 11:48 AM.

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

About Us

"It's about Microsoft Excel"