pivot table empty cell

S

Shannon

I need to have an empty cell be in the pivot table. I have multiple
pivot tables I have generated for a report. I have created a
worksheet that reads the data from the pivot table (so it looks
nicer). I have tried to check the box in options that says to put a 0
or another symbol (*) in an empty cell and it doesn't work. I want
people to be able to input their own data and refresh the pivot table.
If I have four response options (sometimes, always, never, usually)
and the new data does not have data for one of the options then the
table that reads the data gets messed up with its numbering. Is there
anyway I can fix this?

Thanks, Shannon
 
D

Debra Dalgleish

Double-click on the Response field button
Add a check mark to 'Show items with no data', click OK
 
S

Shannon

Debra Dalgleish said:
Double-click on the Response field button
Add a check mark to 'Show items with no data', click OK
Click to expand...

I don't see that as an option in the response field button. I really
want each response to have a column. I have all of the response
options checked. Any suggestions? Thanks for your help.
 
Top