Usign Excel 2000 on an XP box:
I have a client who wants to create a Pivot Table using a spreasheet with
approx. 1500 rows of data and 8 columns. When she creates the Pivot Table,
she gets an error message saying that she is trying to add too many rows
and/or columns. The Pivot Table contains one Page Field, One Column Field,
one Data field and will only allow her 3 Row fields. When she tries to add
the 4th Row Field, she gets the error telling her she is trying to add too
many fields. According to the Excel Help Specifications sheet, the number of
Row and Column fields for Pivot Tables is limited by available memory. Her
PC has 1 GB of RAM and the spreadsheet's file size is just over 1 MB. No
other applications are open. Can anyone explain why she is getting this
error, and if there is a way to work around it.
All help is greatly appreciated -Thx.
LPS
--
LPS