When I create a pivot table - there is a column included with "Comments".
Where ever there are no comments in the data table - the pivot table has
"(blank)". For items that have no data I want to just show a blank.

In Pivot Table Options - for empty cells - I put in a space and yet I keep
seeing text - blank.

Thanks in advance for the help.

The Blank setting you are refering to pertains to blank data items, not
categories.
You should be able to click the drop-down at the top of the category and
uncheck Blank to hide those items.

Does that help?

--
Regards,
Ron

Thanks Ron. I want those items to be displayed. But I just do not want it
to say "blank".

Thanks.

"Ron Coderre" wrote:

The Blank setting you are refering to pertains to blank data items, not
categories.
You should be able to click the drop-down at the top of the category and
uncheck Blank to hide those items.

Does that help?

--
Regards,
Ron

Your problem is that the setting in the table options refers to the data
area. If you deselect the dropdown in the comments field so that blank
doesn't show up, it will eliminate the line altogether from the pivot. I
THINK you are trying to avoid, in your row description area (before you get
to showing data like a count or sum total), the printing of the word blank.
In that case. I would suggest you go to your raw data, autofilter the list,
select the "blanks" under the comments column, and then highlight the whole
lot, replacing them with a " " (space). This way, when your pivot draws the
data, it will not be drawing literal blank fields, but rather a seemingly
blank value, which in actuality is a space (which shows up as nothing in the
pivot). Hope that's what you were getting at.
--
Boris


"dipsy" wrote:

When I create a pivot table - there is a column included with "Comments".
Where ever there are no comments in the data table - the pivot table has
"(blank)". For items that have no data I want to just show a blank.

In Pivot Table Options - for empty cells - I put in a space and yet I keep
seeing text - blank.

Thanks in advance for the help.

You can change the caption:

In the pivot table, select one of the cells that says (Blank)
Type a space character
Press Enter

dipsy wrote:
When I create a pivot table - there is a column included with "Comments".
Where ever there are no comments in the data table - the pivot table has
"(blank)". For items that have no data I want to just show a blank.

In Pivot Table Options - for empty cells - I put in a space and yet I keep
seeing text - blank.

Thanks in advance for the help.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi

I have a VERY LARGE pivot table. As I have to loop through one of the pivot
fields (month of year) to show data by quarters it can take a long time to
complete the query as the pivot table refreshes on every occasion it
hides/unhides a pivot item. Is there any way I can hide/unhide pivotitems
simulataneously without going through a loop.?
Thanks
Rupster

I don't know of any way to hide/show pivot all items without looping.
Make sure you have manual update turned on, e.g.:

ActiveSheet.PivotTables(1).ManualUpdate = True


Rupster wrote:
Hi

I have a VERY LARGE pivot table. As I have to loop through one of the pivot
fields (month of year) to show data by quarters it can take a long time to
complete the query as the pivot table refreshes on every occasion it
hides/unhides a pivot item. Is there any way I can hide/unhide pivotitems
simulataneously without going through a loop.?
Thanks
Rupster


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html