View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Limitations with Pivot Tables

Yes, I think so. Can you convert the file to Excel 2007 format? That
should allow the higher limits.

Pelos wrote:
Debra, thanks for your reply. I did add the field to the row labels area to
the pivot table layout, and yes, the workbook was created on an earlier
version of Excel (2003) and I'm using compativility mode, do you think that
the compatibility mode is the one that is causing the problem?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html