how do i remove cells with no data in them on a pivot table in excel 2000

Giganews Newsgroups
Subject: how do i remove cells with no data in them on a pivot table in excel 2000
Posted by:  Chris
Date: Fri, 24 Oct 2003

how do i remove cells with no data in them on a pivot table in excel 2000.  I have tried ticking the box 'remove rows with no data' but they are still there.  I have tried everything,

can canyone help please?

Replies