Hide zeros and empty data in Pivot Tables

M

Mark Frank

Hi all,

I am running Office XP. Does anyone know of a way to hide
zeros and empty data through the normal Pivot Table
functionality? If this feature exists in OWC, would it
make sense to create the PT in OWC then export it back to
Excel?

Thanks in advance,

Mark
 

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

Hiding blank cells within a Pivot Table 1
Pivot Table Hide Zero Subtotals - Excel 2007 4
Pivot Table Wizard causes crash 1
Retain pivot table formatting after refreshing data 0
Summarize Linked Data with Pivot Tables 0
Pivot table NOT showing zero value calculations 2
Publish Access 2007-2010 pivot table to the web? 7
#N/A values when exporting PivotTable to Excel 0

Top