| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why does (blank) display on pivot table
I have created a pivot table and a couple of columns that I have used have no
data in them. However those columns are displaying (blank) in the pivot table. I need it to not display anything so that once the pivot is printed the field can be written in. I have deleted all data in those columns, under 'options' I have checked 'For empty cells show...' and erased the field next to it but it still displays in the pivot table as (blank). Your thoughts...thanks JP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
