|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 23rd, 2004, 01:25 AM
|
|||
|
|||
whats the best way do a link to pivot table data.
if i do a direct reference to the pivot table, and then the pivot table
changes, especially when the size of the pivottable, (i.e number of columns and rows)... then the reference to the pivot table stuffs up. so wahts the best way to use the data from the pivot table? cheers --- Message posted from http://www.ExcelForum.com/ 
|
|
#2
July 23rd, 2004, 01:58 AM
|
|||
|
|||
|
whats the best way do a link to pivot table data.
Try Debra Dalgleish's nice coverage
on dynamic data source for pivot table at: http://www.contextures.com/xlPivot01.html -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "sokevin " wrote in message ... if i do a direct reference to the pivot table, and then the pivot table changes, especially when the size of the pivottable, (i.e number of columns and rows)... then the reference to the pivot table stuffs up. so wahts the best way to use the data from the pivot table? cheers --- Message posted from http://www.ExcelForum.com/
|
|
#3
July 23rd, 2004, 02:10 AM
|
|||
|
|||
|
whats the best way do a link to pivot table data.
You can use the GETPIVOTDATA function. There are examples in Excel's
help, and he http://www.contextures.com/xlPivot06.html sokevin wrote: if i do a direct reference to the pivot table, and then the pivot table changes, especially when the size of the pivottable, (i.e number of columns and rows)... then the reference to the pivot table stuffs up. so wahts the best way to use the data from the pivot table? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
|
#4
July 23rd, 2004, 02:21 AM
|
|||
|
|||
|
whats the best way do a link to pivot table data.
Oops, wrong reading of post, sorry ..
... lucky for me, Debra's on-line at the moment.. bg -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ----
|
|
#5
July 23rd, 2004, 04:12 AM
|
|||
|
|||
|
whats the best way do a link to pivot table data.
|
|
#6
July 23rd, 2004, 04:33 AM
|
|||
|
|||
|
whats the best way do a link to pivot table data.
Pleasure' Kev!
Thanks for the feedback lots for me to learn .. ... this applies to me, too, btw g imo, every post would carry an "implicit" lesson or 2 Cheers -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- "sokevin " wrote in message ... thanks again. lots for me to learn cheers kev  --- Message posted from http://www.ExcelForum.com/
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Month Data in a Pivot Table? | Kent | General Discussion | 3 | July 14th, 2004 01:32 AM |
| SPECIFYING SOURCE DATA INTO A PIVOT TABLE | Sheron Donaldson | Worksheet Functions | 1 | May 21st, 2004 10:41 PM |
| Static Chart using Pivot Table and other data | Will | Charts and Charting | 1 | January 15th, 2004 09:41 PM |
| Pivot table chart - Data labels | Rick | Charts and Charting | 1 | October 14th, 2003 05:06 PM |
Linear Mode
