| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i avoid a formula in excel2003 automatically using getpivot
if i try to enter a simple formula using a cell within a pivot table excel
2003 automatically uses the getpivotdata function. This is not always required and did not happen in 2000. Any way to avoid this ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i avoid a formula in excel2003 automatically using getpivot
Check Debra Dalgleish's site:
http://contextures.com/xlPivot06.html#GetPivotData Peterhine21 wrote: if i try to enter a simple formula using a cell within a pivot table excel 2003 automatically uses the getpivotdata function. This is not always required and did not happen in 2000. Any way to avoid this ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2003 - Automatically sum a variable number of rows | Excel Worksheet Functions | |||
| cancelling getpivot formula when setting formula outside pivot ta. | Excel Worksheet Functions | |||
| How do I avoid fields being automatically filled in by default? | New Users to Excel | |||
| copying formula into non-adjacent cells, EXCEL2003 | Excel Discussion (Misc queries) | |||
| Pie Charts Resize Automatically - How To Avoid? | Charts and Charting in Excel | |||
Linear Mode
