I am working in a pivot table that was working fine, until I added data to the source document.

In essence, I added 2013 data as a series of 4 new columns. One of the 4 columns works correctly in the pivot table - that is it sums the values of the dollar amounts in the column related to the account name (row designator). The other 3 rows pull in values of $0 and I can't figure out why.



Please help!

that when I tried to suss this out before, apparently there was a formatting problem in those columns, but I can't figure out how to find it!

Hi and welcome

without seeing your data there is no way to tell. Could you please post a sample sheet? Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Peco,

Thank you so much for your input - I will know that for the next time I get stuck.

I found out that some of my data had transferred in as text format, not number format, so ended up manually converting every cell that was supposed to be numbers into a number format by mutiplying them by a cell that had the figure 1 in them.

I first started by taking my original spreadsheet, adding another worksheet, copy/paste data as values into the 2nd worksheet. Then I went through and reformated all 50+ columns using the method above for columns with numbers. It worked, but it wasn't pretty.

There HAS to be an easier way - but right now I am just so happy the pivot table isn't broken any more. Of course, I am probably going to run into the same issue next year when I add the data for 2014.

One of the ways to transform text to numbers is to select them (all at once is OK) then go to the Data ribbon - Click Text to columns - Then " Finish"

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post