Not and keep it a pivottable.
You could convert the PT to values (or copy|paste special|values to a new sheet)
and then fill the cells on that copy.
See Debra Dalgleish's site for tips to fill those empty cells:
http://contextures.com/xlDataEntry02.html
Richard wrote:
When using pivot tables, Excel only fills the first cell in a particular
column for each section or category of data. Is there a way to get the pivot
table to fill all the data elements to have a completely filled in
spreadsheet? I would like to format or even possibly complete another pivot
based on the results but I can not do that unless everything is filled in.
Thanks for your help.
--
Dave Peterson