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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
It may be that the total is zero rather than having no data.

Double click the PT blank value cell to see if there are, in fact,
records there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
pivot table in Excel 2007 & 2000 (backward compatibility problem) 3
Display No Data in Pivot 1
Refreshing Pivot Table on a protected spreadsheet tab 1
Access #Error & Excel Pivot 0
Clear row label data in pivot table 2
Pivot using 250,000 rows of data in Excel? 1
How do I save Pivot Table Data 4

Back
Top