Solved: Excel 2007/2010 Pivot Table data error

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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:
 
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!
 

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top