Remove (blank) from pivot table

Anonymous

Hi,

My source data has empty cells. When I PT this data - the PT shows "(blank)" for the empty cells. How can I keep the cells "empty" in the PT. I do not want to manually filter and uncheck (blank) as this removes other data which is needed.

TIA,

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Excel 2007/2010 PivotTable

Show blank cell instead of (blank)

in RowField/ColumnField item labels.

http://c3017412.r12.cf0.rackcdn.com/01_23_11.xlsx

If you get *.zip, don't unzip, just rename *.xlsx

0 comments

46 additional answers

Anonymous

2013-10-24T19:56:09+00:00

Thank you Ashish! Tht's the only thing that worked :)
Was this answer helpful?

0 comments No comments
Anonymous

2013-08-22T15:38:11+00:00

You saved my day! Had a last minute fix to my pivot and (blank) was out of the questions for a report to be shown to upper management. THANK YOU !
Was this answer helpful?

0 comments No comments
Ashish Mathur 102.4K Reputation points Volunteer Moderator

2013-03-22T22:38:14+00:00

Hi,

A ' in a cell is effectively an empty cell.
Was this answer helpful?

0 comments No comments
Anonymous

2013-03-20T02:21:00+00:00
Hi,

If you do not wish to change the source data, then try this

Select the pivot table (Ctrl+A while on any cell in the pivot table)

Press Ctrl+H

In the Find box, type (blank)

In the Replace with box, type '

Click on Replace All

Hope this helps.
Is there a way to do this against a PowerPivot Table? When I tried the method above, the ' did replace the (blank) but displayed as is rather than with a blank field.

Thanks,

Amy
Was this answer helpful?

0 comments No comments