Hiding Zero Values in a Pivot Table - MS Excel 2007
 

Does anyone know how to hide zero values in a pivot table in MS Excel 2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007. Does
anyone know how to do this? Thanks.

Hiding Zero Values in a Pivot Table - MS Excel 2007
 

Hi

Press the round Office buttonExcel OptionsAdvancedDisplay options for
this worksheetun-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cellPivot Table OptionsLayout &
Format there is an options to check For Empty cell Show decide on
character to be used.

--
Regards
Roger Govier

"Taveras" wrote in message
...
Does anyone know how to hide zero values in a pivot table in MS Excel
2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007.
Does
anyone know how to do this? Thanks.

Hiding Zero Values in a Pivot Table - MS Excel 2007
 

Hi -

Following those steps just makes the zero's come out as dashes.

What I'd like to do is remove or hide the entire rows that have zero values
in pivot tables. I guess maybe it wasn't clear from the post.

Thanks.

"Roger Govier" wrote:

Hi

Press the round Office buttonExcel OptionsAdvancedDisplay options for
this worksheetun-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cellPivot Table OptionsLayout &
Format there is an options to check For Empty cell Show decide on
character to be used.

--
Regards
Roger Govier

"Taveras" wrote in message
...
Does anyone know how to hide zero values in a pivot table in MS Excel
2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007.
Does
anyone know how to do this? Thanks.

Hiding Zero Values in a Pivot Table - MS Excel 2007
 

Hi

You must have you data formatted in a special way. Mine just shows blank
cells.
Try
right clicking on a fieldField SettingsLayout & Printremove check mark
from Show items with no data.
--
Regards
Roger Govier

"Taveras" wrote in message
...
Hi -

Following those steps just makes the zero's come out as dashes.

What I'd like to do is remove or hide the entire rows that have zero
values
in pivot tables. I guess maybe it wasn't clear from the post.

Thanks.

"Roger Govier" wrote:

Hi

Press the round Office buttonExcel OptionsAdvancedDisplay options for
this worksheetun-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cellPivot Table OptionsLayout &
Format there is an options to check For Empty cell Show decide on
character to be used.

--
Regards
Roger Govier

"Taveras" wrote in message
...
Does anyone know how to hide zero values in a pivot table in MS Excel
2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007.
Does
anyone know how to do this? Thanks.

Hiding Zero Values in a Pivot Table - MS Excel 2007
 

Where you able to fix that thing Taveras? Im having the same problem
and I havent found a good solutions

On Sep 5, 12:56*am, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
Hi

You must have you data formatted in a special way. Mine just shows blank
cells.
Try
right clicking on a fieldField SettingsLayout & Printremove check mark
from Show items with no data.
--
Regards
Roger Govier

"Taveras" wrote in message

...



Hi -

Following those steps just makes the zero's come out as dashes.

What I'd like to do is remove or hide the entire rows that have zero
values
in pivot tables. *I guess maybe it wasn't clear from the post.

Thanks.

"Roger Govier" wrote:

Hi

Press the round Office buttonExcel OptionsAdvancedDisplay options for
this worksheetun-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cellPivot Table OptionsLayout &
Format there is an options to check For Empty cell Show decide on
character to be used.

--
Regards
Roger Govier

"Taveras" wrote in message
...
Does anyone know how to hide zero values in a pivot table in MS Excel
2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007.
Does
anyone know how to do this? *Thanks.- Hide quoted text -

- Show quoted text -