| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
pivot table calculations
In the 2003 version attempts to calculate from the pivot table generates a
long fomula including an absolute referece - therefore you can't copy the formula down the column. Is there a way to automatically use relatational reference rather than absolute reference?-- Joe S. |
|
#2
|
|||
|
|||
|
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html Joe S. wrote: In the 2003 version attempts to calculate from the pivot table generates a long fomula including an absolute referece - therefore you can't copy the formula down the column. Is there a way to automatically use relatational reference rather than absolute reference?-- Joe S. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| using the PIVOT TABLE and CHART | Excel Discussion (Misc queries) | |||
Linear Mode
