Pivot Table where field shows bad values

Kggoodwin · Feb 20th, 2002, 08:35 AM

Some of the Fields in our Pivot Tables show values that do not apply to that field. We have not figured out how this happened or how to clean it up. We are using Excel 2000.
Any clues on the why and how of this?

THANKS...Kgg

_________________

[ This Message was edited by: Kggoodwin on 2002-02-20 07:36 ]

Mark W. · Feb 20th, 2002, 08:49 AM

Sounds like your data was modified incorrectly. Your problem statement doesn't provide enough clues. What's the source of the data for your PivotTable?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 08:35 AM	#1
Kggoodwin New Member Join Date: Feb 2002 Posts: 1	Some of the Fields in our Pivot Tables show values that do not apply to that field. We have not figured out how this happened or how to clean it up. We are using Excel 2000. Any clues on the why and how of this? THANKS...Kgg _________________ [ This Message was edited by: Kggoodwin on 2002-02-20 07:36 ]

Feb 20th, 2002, 08:49 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Sounds like your data was modified incorrectly. Your problem statement doesn't provide enough clues. What's the source of the data for your PivotTable?