| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
GET PIVOT DATA
Just upgarded Excel version. In my previous version I had no trouble adding cells displayed in the PT. Assuming I have cell A,B&C inside the PT In D I just sum (+AI+B1+CI) However the upgraded version does not allow me to do this. Instead It starts with +GETPIVOTDAT(cell). This is too long and I also have trouble copying down because it seems to be hard coded only to D1. Cell D2, D3 etc will show same formula as D1. Tried to look up in Help but does not show how I can "disable" this and use back the earlier formula. This can be done but I have to manually type in the cell reference instead of using the + key. Please help |
|
#2
|
|||
|
|||
|
Hi
see: http://www.contextures.com/xlPivot06.html "sythong" wrote: Just upgarded Excel version. In my previous version I had no trouble adding cells displayed in the PT. Assuming I have cell A,B&C inside the PT In D I just sum (+AI+B1+CI) However the upgraded version does not allow me to do this. Instead It starts with +GETPIVOTDAT(cell). This is too long and I also have trouble copying down because it seems to be hard coded only to D1. Cell D2, D3 etc will show same formula as D1. Tried to look up in Help but does not show how I can "disable" this and use back the earlier formula. This can be done but I have to manually type in the cell reference instead of using the + key. Please help |
|
#3
|
|||
|
|||
|
Frank
Thanks. Will do. -----Original Message----- Hi see: http://www.contextures.com/xlPivot06.html "sythong" wrote: Just upgarded Excel version. In my previous version I had no trouble adding cells displayed in the PT. Assuming I have cell A,B&C inside the PT In D I just sum (+AI+B1+CI) However the upgraded version does not allow me to do this. Instead It starts with +GETPIVOTDAT(cell). This is too long and I also have trouble copying down because it seems to be hard coded only to D1. Cell D2, D3 etc will show same formula as D1. Tried to look up in Help but does not show how I can "disable" this and use back the earlier formula. This can be done but I have to manually type in the cell reference instead of using the + key. Please help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
| Help with pivot charts and data labels | Charts and Charting in Excel | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Linear Mode
