+ Reply to Thread
Results 1 to 2 of 2

Pivot Table - Eliminate the updating on certain fields

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211

    Pivot Table - Eliminate the updating on certain fields

    Is there a way to make a specific field on a pivot table excluded from an update?
    We use MANY different pivot tables with large amounts of data. So we might have CODE and Count. We only want to see certain codes, so we choose only those we want to see. New codes are added often, but what we want to see doesn't change. It automatically adds all the new codes on update and we have to go into every column on many pivot tables to un-check those new codes. Can I update all the data on that pivot table, but not allow new codes to be added to our filtered CODE column? Thanks so much for your help.

  2. #2
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211

    Re: Pivot Table - Eliminate the updating on certain fields

    Does anyone have a suggestion for this?

+ 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. [SOLVED] Stop Pivot from updating as I change fields
    By jomili in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-16-2017, 08:44 AM
  2. Hide fields(table columns) from Pivot table Fields
    By alexholly in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-28-2017, 08:24 PM
  3. Replies: 2
    Last Post: 10-26-2015, 06:49 AM
  4. [SOLVED] Dynamically updating fields in Pivot Table
    By SandPounder1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2014, 04:00 PM
  5. How to Disable automatic fields in pivot table like total and count on fields
    By anushka in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-24-2009, 07:53 AM
  6. Differentiate between column fields and data fields in a pivot table
    By whiteheadw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2009, 01:59 PM
  7. eliminate pivot table
    By imatomic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-08-2008, 08:41 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