Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Grand Rapids, Michigan, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    I have a large data table that I'm using pivot tables to create a report from. I have created an additional column in my pviot table to be used for a note that goes along with the row of data. I can pull this notes column into my pivot table, but if I don't have anything keyed into the column on the data table, the cells in the pivot table show "(blank)" for all the empty cells. Is there any way to turn this off? I've cheated for now be using a space in each of the data cells but there must be a better way. How can I get rid of these "(blanks)"s? Any help would be appreciated!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    You can dbl-click on that field, and chose (blank) in the "hide Items"

    Steve

  3. #3
    New Lounger
    Join Date
    Apr 2004
    Location
    Grand Rapids, Michigan, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    Sorry - I should have mentioned that I would still like to show the row of data that contains the empty cell. As soon as I deselect blank in hide items, the row of data goes away with the blank cell.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    Then I think you need to add something to the cell so that the privot routine does not see a blank cell. A "space" as you suggested or something else "Not commented" perhaps

    Steve

  5. #5
    New Lounger
    Join Date
    Apr 2004
    Location
    Grand Rapids, Michigan, USA
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    Thanks. What I'm doing with the spaces seems to work but I just thought there must be a more elegant solution. Why can't it just be left blank? I can see that it's blank - I don't need Excel to tell me something I can already see... I can understand wanting to sort out blank fields but it would be nice to give the option of what to show if a cell is empty.

    Bryan

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Getting rid of (blank)s in Excel 2003 pivot tables (2003)

    On some levely you can, put whatever you want to display in the cells instead of leaving them blank <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Steve

Posting Permissions

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