+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Show Details has stopped working

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    Bedford
    MS-Off Ver
    Excel 2010
    Posts
    10

    Pivot Table Show Details has stopped working

    I have used show details on pivot tables for years but all of the sudden it has stopped working and now when I double click on a total or right click "show details" I get hundreds more records than the number shown. I have been into Pivot table Options and disabled "show details" and tried again then I have re-enabled and tried again but the same happens. Am at a total loss.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Pivot Table Show Details has stopped working

    Show details returns all the data that matches the criteria in force. In this case those criteria are Fire, GB and 2014, which results in 379 records. It does not (and never has) return only the rows that actually have data in a particular field.

+ 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. Formatting of SHOW DETAILS in PIVOT TABLE
    By whatever61 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-30-2016, 04:00 PM
  2. Show details of pivot table in the same worksheet
    By jaryszek in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-16-2016, 10:01 AM
  3. Pivot table show details macro
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-27-2012, 11:15 PM
  4. Pivot table's Group and show details not available
    By gideone in forum Excel General
    Replies: 1
    Last Post: 08-31-2011, 10:08 AM
  5. Replies: 4
    Last Post: 05-10-2011, 02:44 AM
  6. PIVOT TABLE - Show Details query
    By rich534714 in forum Excel General
    Replies: 2
    Last Post: 02-17-2011, 06:30 AM
  7. Pivot Table ..Show Details Report
    By tariqnaz2005 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2009, 04:55 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