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.