+ Reply to Thread
Results 1 to 2 of 2

Removing Blank Cells in the Pivot Table. (Blank) - Out of Range Cells

  1. #1
    Registered User
    Join Date
    06-25-2019
    Location
    Las Vegas
    MS-Off Ver
    Office 2013
    Posts
    2

    Removing Blank Cells in the Pivot Table. (Blank) - Out of Range Cells

    I want to remove (blank) from Piviot table.
    Steps to Reproduce:
    1. I have data set (5 columns) without any blank cells.
    2. I create Piviot table with this data set.
    3. I add more data to the data set and refresh the Piviot table.
    3. (blank)appears in the piviot table.
    4. As per my research, the piviot is considering the cells after the data till the end of the sheet.
    HELP: Please suggest a macro on how to ignore the blank cells at the end of the data set Sheet and avoid (blank) appearing in the piviot table.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,946

    Re: Removing Blank Cells in the Pivot Table. (Blank) - Out of Range Cells

    Why do you have to include blank cells in the data source ?
    Can't you use a dynamic range as described at https://www.contextures.com/excelpiv...ourcedata.html

+ 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. Help removing blank cells in range
    By maym in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 09-28-2017, 10:35 PM
  2. Count blank cells in a range and contiguous blank cells also as single cells! Tricky One!
    By SebastianColombia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2015, 02:32 PM
  3. Pivot table in blank cells it says blank.... i want it empty
    By appell in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2014, 09:43 AM
  4. 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
  5. Need to count Blank cells instead of data cells in Pivot table
    By plb999 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-19-2012, 09:01 PM
  6. Advanced filter with blank cells / Dynamic named range with blank cells
    By Jason_2112 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2010, 12:06 PM
  7. removing the word (blank) from pivot table cells
    By techman41973@yahoo.com in forum Excel General
    Replies: 2
    Last Post: 07-02-2005, 10:05 PM

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