+ Reply to Thread
Results 1 to 2 of 2

Pivot table in blank cells it says blank.... i want it empty

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    abidjan
    MS-Off Ver
    Excel 2010
    Posts
    1

    Pivot table in blank cells it says blank.... i want it empty

    HI,

    So I am working on my pivot table.

    When there are no datas in the cell the pivot table says blank. I want it to stay empty.

    Does anybody have a clue on how to do this?

    Thank you

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Pivot table in blank cells it says blank.... i want it empty

    You can go into the cell in the pivot table, and change "(blank)" to " ".
    The pivot table will then always show all "(blank)" entries as " ".
    Unfortunately, it is still not literally empty, but... it appears that way. Will it work?
    Please click the * icon below if I have helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot table picks up empty cell from formula which returns BLANK
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 08:37 PM
  2. Pivot Table Field - Blank Cells without text "(blank)"
    By WRX in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-19-2013, 12:10 PM
  3. Pivot Table Blank Cells
    By excelit in forum Excel General
    Replies: 5
    Last Post: 04-25-2011, 04:01 PM
  4. Replies: 1
    Last Post: 03-16-2011, 11:59 PM
  5. [SOLVED] Pivot table blank/empty cells
    By Alan Synnott in forum Excel General
    Replies: 1
    Last Post: 08-03-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1