Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables. It appears to be showing field headers that don't exist in my data???? I'm using Excel 2000. |
#2
![]() |
|||
|
|||
![]()
Debra Dalgleish has some techniques at:
http://www.contextures.com/xlPivot04.html In fact, she has an addin that you may like: http://www.contextures.com/xlPivotAddIn02.html AHuntington wrote: Can anyone help with some bizarre results I'm experiencing with the show items with no values check box in the field settings menu for pivot tables. It appears to be showing field headers that don't exist in my data???? I'm using Excel 2000. -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
There's information here on clearing old items in a pivot table:
http://www.contextures.com/xlPivot04.html AHuntington wrote: Can anyone help with some bizarre results I'm experiencing with the show items with no values check box in the field settings menu for pivot tables. It appears to be showing field headers that don't exist in my data???? I'm using Excel 2000. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot tables show zeros | Excel Discussion (Misc queries) | |||
How to show data greater than 10 in pivot table | Excel Discussion (Misc queries) | |||
How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |