Howdy and welcome to the board. What version of Excel are you using? If not 2007, then it sounds like you are trying to put too many items into columns, exceeding the 256 column limit. Try to move the customers to the rows of the pivot table rather than in columns.
old, slow, and confused
but at least I'm inconsistent!