1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 2007/2010 Pivot Table data error

Discussion in 'Business Applications' started by Trevors726, Jan 14, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. Trevors726

    Trevors726 Thread Starter

    Joined:
    Jan 7, 2013
    Messages:
    7
    I have an excel spread sheet that pulls data from multiple seperate sheet to then consolidate them into a single table that then uses a pivot table to pull together a 'class' list of everyone starting a set classs on the same day and venue with their contact details on including a phone number. For 1 person on the list the pivot table has added an additional 2 to the end of the phone number.

    I have checked the original spreadsheet, the consolidated sheet and neither of thiose has the extra digit in it only shows on the pivot table.

    The pivot table is set up with tabular layout so you get 1 line per person who meets the filters set to class start date and venue and i have checked that the column on the pivot table is formated the same all the way down.

    Does anyone have an idea how the extra digit arrived and how i get rid of it? I have over trypwed the original data on the colsolidated list with some thing differnt and refreshed and then put the content back to the refernce cell and the extra 2 re appears - all very confusing :mad:
     
  2. draceplace

    draceplace

    Joined:
    Jun 8, 2001
    Messages:
    2,583
    Very hard to trouble shoot this on written notes. To find this... I would try moving/adding the person to another class. I would also try pivoting on class members and see how this entry appears. If still an issue I would make this thing with only the offending records and associated records. Excel usually doesn't make this stuff up.

    In reality I would send this off and call it done!
     
  3. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Maybe the number is a duplicate.
     
  4. Trevors726

    Trevors726 Thread Starter

    Joined:
    Jan 7, 2013
    Messages:
    7
    Thanks for your thoughts - i have tried to sort and re make the pivots and still cant find why the extra 2 appears - weird
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1085134

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice