In my pivot table I have a lot of cells without any data. The report looks like garbage with all the (BLANK) sohowing up in the report.
I've tried condtional formatting where if the cells = (BLANK) it woulf format them as white -did not work
I tried the pivot table options and clicking on the box "for empty cells show" and set it to 0 then empty but that did not work.
any Ideas???
Thanks
I've tried condtional formatting where if the cells = (BLANK) it woulf format them as white -did not work
I tried the pivot table options and clicking on the box "for empty cells show" and set it to 0 then empty but that did not work.
any Ideas???
Thanks