Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table refresh error
I have a pivot table that refreshes fine on my computer but not on a
collegues. He gets an error sying there are too many rows or columns. I have 6 fields in the row area. I'm on 2003 SP 2 and he is on 2000. Is this the issue? Or will I get lucky and find an easier fix? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table refresh error
The limitations for pivot tables in Excel 2000 are much lower than those
in Excel 2003, so that's the issue. These MSKB articles outline the limits for Excel 2000 and Excel 2003: 2003 -- Description of the limits of PivotTable reports in Excel http://support.microsoft.com/kb/820742/ 2000 -- Limits of PivotTables in Excel http://support.microsoft.com/kb/211517/ Darby wrote: I have a pivot table that refreshes fine on my computer but not on a collegues. He gets an error sying there are too many rows or columns. I have 6 fields in the row area. I'm on 2003 SP 2 and he is on 2000. Is this the issue? Or will I get lucky and find an easier fix? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Pivot Refresh Error | Excel Discussion (Misc queries) | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
Pivot Table will not refresh | Excel Discussion (Misc queries) | |||
Pivot Table Refresh | Excel Discussion (Misc queries) | |||
Pivot Table Refresh | Excel Worksheet Functions |