Hi all
Wonder if anyone can suggest a way around this one, I created a spreadsheet with fairly simple data being entered which I built a pivot from, problem I am having is the comments fields seem to only pull across part of the comment input. I tried changing the format from General to Text but it makes no difference, am i missing something on pivot character limits/restrictions or something?

There is a fair amount of text in the comments field so really just need to know if the pivot has a limitation and if there's a way around it.

Many thanks