When I try to drag a particular field into the Page area, Excel tells me that
"the field you are moving cannot be placed into that Pivot Table area". The
data in the column concerned is text, so I can't understand it's not allowing
me to place it there. I've looked at the field settings and there doens't
appear to be anyhthing untoward there. The message box is next to useless at
explaining why I can't drag it into the page area (but I can drag it to the
Row or Column area)- does anyone have an explanation?