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
Bookmarks