+ Reply to Thread
Results 1 to 2 of 2

"Show items with no data on rows" grayed out on PivotTable Options in 2016

  1. #1
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    "Show items with no data on rows" grayed out on PivotTable Options in 2016

    I have searched for this, and cannot find an answer for 2016. The PivotTable Options menu is a little different from the other versions compared to 2016.

    The checkbox is grayed out for "Show items with no data on rows" and "Show items with no data on columns" in the PivotTable Options. I cannot figure out why. Help?

    Thanks!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    07-14-2013
    Location
    USA
    MS-Off Ver
    MS 365
    Posts
    97

    Re: "Show items with no data on rows" grayed out on PivotTable Options in 2016

    If you would attach a desensitized copy of your workbook with the pivot table, we will be better able to help you.

+ 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. Replies: 2
    Last Post: 07-15-2016, 10:04 AM
  2. "Show items with no data" does not work
    By maunzDK in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-02-2015, 09:13 AM
  3. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 PM
  4. VBA Slice Setting "Show Items Delete from the Data source"
    By milobc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 08:37 PM
  5. Replies: 2
    Last Post: 01-26-2011, 06:45 AM
  6. [SOLVED] EXCEL allow 2 options on status bar e.g. show "Count" + "Sum"
    By LEJM in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 06:50 AM
  7. [SOLVED] Is there anyone knows PivotTable about "Select multiple items"(Urg
    By Microlong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2005, 10:07 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