Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Data source for Multiple Pivots
Hi, I have used the same data for multiple pivot tables. The Data keeps on changing and the rows gets added and deleted. So everytime I have to go to all the pivot table and change the Datasource range. Is there anymethod that can be used, which will automatically adjust the datasource range for all the pivots without intervetion. Please educate. Thanks & Regards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=559203 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Data source for Multiple Pivots
Hi Anand
adjust your datasource more than data you expect to come & set option "refresh on open" in pivot table option if you don't use external data. hope it will help. "anandmr65" wrote: Hi, I have used the same data for multiple pivot tables. The Data keeps on changing and the rows gets added and deleted. So everytime I have to go to all the pivot table and change the Datasource range. Is there anymethod that can be used, which will automatically adjust the datasource range for all the pivots without intervetion. Please educate. Thanks & Regards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=559203 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Data source for Multiple Pivots
Hi
Create a Dynamic range for your data, and use the name of the range as the data source for your PT. For help on constructing a named dynamic range take a look at Debra Dalgleish's site http://www.contextures.com/xlNames01.html#Dynamic -- Regards Roger Govier "anandmr65" wrote in message ... Hi, I have used the same data for multiple pivot tables. The Data keeps on changing and the rows gets added and deleted. So everytime I have to go to all the pivot table and change the Datasource range. Is there anymethod that can be used, which will automatically adjust the datasource range for all the pivots without intervetion. Please educate. Thanks & Regards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=559203 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same Data source for Multiple Pivots
Hi Roger Govier & Samad, Thanks a lot for the resolution. Thanks & Regards Anand -- anandmr65 ------------------------------------------------------------------------ anandmr65's Profile: http://www.excelforum.com/member.php...o&userid=30728 View this thread: http://www.excelforum.com/showthread...hreadid=559203 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting source data that I want | Excel Discussion (Misc queries) | |||
How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |