+ Reply to Thread
Results 1 to 7 of 7

Pivot table unexplained data

  1. #1
    Registered User
    Join Date
    04-19-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    7

    Thumbs up Pivot table unexplained data

    This is driving me crazy:

    I have a table of text data and the first column has equipment numbers. All are collated on the Pivot table correctly except one "PS4". I have deleted the data, pasted as values, typed manually, formatted etc. but I still get the following result on the Pivot:

    Data Table:
    PS4

    Pivot Table:
    lkkkl;;;'lll

    I thought someone in Microsoft was trying to mess with anyone using a Sony PS4 so I created a bank document and the Pivot works fine with PS4 in the data table, I'm lost. All help appreciated.

    When I add a space in the equipment number to "PS 4" it works fine, see pivot screenshot attached.

    Added Excel file, I had to remove most of the data for confidentiality reasons but hopefully, this works to show the error.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by funkyman1969; 12-07-2020 at 08:19 AM. Reason: Added excel

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Pivot table unexplained data

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    04-19-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    7

    Re: Pivot table unexplained data

    Thanks, attached a sheet now!

  4. #4
    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 unexplained data

    And the password is... ?
    Rory

  5. #5
    Registered User
    Join Date
    04-19-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    7

    Re: Pivot table unexplained data

    Sorry! will attach password-free version now!

  6. #6
    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 unexplained data

    It looks like someone just overtyped the caption. You can just type over it again.
    Last edited by rorya; 12-07-2020 at 07:16 AM.

  7. #7
    Registered User
    Join Date
    04-19-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    7

    Re: Pivot table unexplained data

    Quote Originally Posted by rorya View Post
    It looks like someone just overtyped the caption. You can just type over it again.
    Thanks, I didn't even know you could do this! Fixed now.

+ 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. Add custom column to Pivot Table or update Source data FROM pivot table
    By jschneiter2 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 08-20-2020, 03:04 PM
  2. Replies: 21
    Last Post: 05-10-2018, 09:25 AM
  3. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  4. Automating Pivot table and pivot chart creation if data table names unknown
    By Vegiepie2016 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-04-2016, 11:52 AM
  5. [SOLVED] Large data set gives unexplained outlier
    By Jose Gregorio in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-05-2015, 01:17 AM
  6. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  7. Replies: 1
    Last Post: 06-20-2010, 04:00 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