+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet

    I have a strange question, I've got a pivot table (and have worked with many) where the data in the spreadsheet shows dealer information and part #'s. The Pivot table used to summarize by Date/Dealership/Part # and do a count for each. When I added data to the spreadsheet this morning and "refreshed" my table, one of the part #'s no longer shows and is now replaced with a " ' ".

    I checked the data in the spreadsheet it is pulling from and the part number is listed throughout the worksheet (112958). The attached picture shows how the pivot is summarizing. I'm guessing there is some formatting change that happened that I don't know about (perhaps by hitting the wrong key), but I can't think of what I might have done to change the part number to show up as " ' " in the pivot.

    Palmetto.jpg
    Last edited by maryren; 09-19-2013 at 10:51 AM.

  2. #2
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    Re: Pivot Table Summary -- Part #'s do not show in Pivot but data is in worksheet

    I solved the issue by creating a new pivot table in a different worksheet. Not sure what the issue was, but it is now solved. Thanks.

+ 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: 12
    Last Post: 08-23-2012, 08:16 AM
  2. [SOLVED] Show part codes only whose have Book qty bal.in Pivot table
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 02-15-2012, 01:57 AM
  3. Pivot Table Summary of Raw Data
    By bee3902 in forum Excel General
    Replies: 1
    Last Post: 12-18-2009, 09:28 AM
  4. exporting summary data for pivot table!
    By via135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2006, 02:16 PM
  5. [SOLVED] How do I show summary totals from a pivot table on a bar chart
    By Colleen T in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 01-21-2005, 10:06 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