| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
two pivot q's - get rid og getpivotdata and pivot based on pivot
Hi,
I've been so lucky as to get new excel and am stuggling with two things I can't do anymore. 1. Remove getpivotdata - if I click in cell B5 I want the formula to use B5 and not lock to a particular cell. 2. Base second, third, etc pivot tables on a first. There's a box for this now, but I've no idea how to use it anymore. I'd really appreciate it if anyone knows how to do these things. Thanks, Light. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
two pivot q's - get rid og getpivotdata and pivot based on pivot
Debra Dalgleish shows how to remove that annoying GetPivotData feature he
http://www.contextures.com/xlPivot06.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Light wrote: Hi, I've been so lucky as to get new excel and am stuggling with two things I can't do anymore. 1. Remove getpivotdata - if I click in cell B5 I want the formula to use B5 and not lock to a particular cell. 2. Base second, third, etc pivot tables on a first. There's a box for this now, but I've no idea how to use it anymore. I'd really appreciate it if anyone knows how to do these things. Thanks, Light. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Conditional Formatting in Pivot Based on other values in pivot. XL | Excel Discussion (Misc queries) | |||
| Pivot Chart based on a pivot table changes | Charts and Charting in Excel | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions | |||
Hybrid Mode
