After finding that excel is bizarrely better at handling pivottables based on very large datasets (as well as having better fromatting), I have found an advantage of Access pivottables that is also frustrating.

Access pivottables can have any field in the data area. Excel insits on some numeric form (eg a count or a max). Hence, Access pivottables seem more flexible - as long as they're working on fairly small tables (or else they hang).

What is frustrating is that such crosstab pivottables do not seem to export to excel. The data area is just left blank in the transferred spreadsheet.

Have I got this limitation correct? Or is it possible to have text in the data area of an excel pivot? If so, why doesnt the Access export work?