Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Thanked 0 Times in 0 Posts

    Another Pivot Table ? - (blank) cells (Excel 2003)

    Okay, here's another question on Pivot Tables.

    Sometimes on my source data worksheet, a cell is empty, or blank. When I create the Pivot Table, any cell that was blank, instead of just being an empty space with nothing on the PT in that area, it says "(blank)", which creates quite a bit of clutter.

    Is there any way I can have it set so that if the source cell is empty, NOTHING shows up in the cell on the Pivot Table, too? I can't find anything that automatically does that, without doing a Search and Replace every time I refresh data.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Another Pivot Table ? - (blank) cells (Excel 2003)

    See this newsgroup post.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts