Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel Pivot Tables - Error Message too many records? Help
My data worksheet is only 1,404 rows and 13 columns (not all data being used)
- but every time I try and add a formula I get an message: "There are too many records to complete the operation". I also have an issue when I go to move from items between the columns and rows - it takes over 15 minutes to refresh. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 Excel Pivot Tables - Error Message too many records? Help
Hi Mak. Hopefully this is not like one of those fake promisses that we heard
from our political candidates... LOL. Well I am afraid that in the Microsoft case, this is one of those. It is true that you can manage formulas in the Pivot Tables and enven mix ranges of two or more different tables to consoidate data in one single PV. However, the big, no HUGE dowsize is the performance of the algorithm behind it. So here are my suggestions: First, drop this idea. Second, try to implement the very same idea, but using cubes. This is a lot more powerful than PV's and offers the same functionality. Third, if First and Second fail, then as I have done in the past, just do the formulas outside the pivot table. THis is one of those features where Microsoft just can keep up with the real needs. Let me know your foundings and best of luck. Argy. "MAK" wrote: My data worksheet is only 1,404 rows and 13 columns (not all data being used) - but every time I try and add a formula I get an message: "There are too many records to complete the operation". I also have an issue when I go to move from items between the columns and rows - it takes over 15 minutes to refresh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Error Message | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "too many records" Excel 2007 | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Error message in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Error Reopening Pivot tables | Setting up and Configuration of Excel |