+ Reply to Thread
Results 1 to 1 of 1

Resize Table - Excluding Blanks After Pivot Change

  1. #1
    Registered User
    Join Date
    04-19-2010
    Location
    Manchester, England
    MS-Off Ver
    Excel 2010
    Posts
    84

    Resize Table - Excluding Blanks After Pivot Change

    Hi All

    Would someone please help with some code.

    I have a pivot table called "DataPivot" and a table called "Report"

    I am looking for code that will refresh the filter on my table (Heading called "No") to excluded blanks when the pivot table changes (after slicer selection).

    Many Thanks



    Diane

    Sorry for not attaching file in first instance.....I was having trouble with the upload.
    Attached Files Attached Files
    Last edited by Maroota; 09-09-2015 at 06:36 AM. Reason: Attached File

+ 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 count excluding zero
    By ammartino44 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-03-2019, 01:03 AM
  2. [SOLVED] Pivot table blanks
    By behrensf84 in forum Excel General
    Replies: 7
    Last Post: 03-31-2014, 04:48 PM
  3. Excel 2007 : Removing blanks from a pivot table
    By benoj2005 in forum Excel General
    Replies: 1
    Last Post: 02-16-2012, 07:38 AM
  4. Excluding non-numeric data from pivot table calcs
    By hemispheres in forum Excel General
    Replies: 1
    Last Post: 01-24-2012, 10:08 PM
  5. Pivot table with blanks
    By timlocke in forum Excel General
    Replies: 4
    Last Post: 07-15-2011, 02:19 PM
  6. Pivot table average excluding zeros
    By Dipwind in forum Excel General
    Replies: 1
    Last Post: 12-17-2010, 09:50 PM
  7. [SOLVED] How do I fill in pivot table blanks?
    By Lisan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2006, 04:15 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