| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables
Does having formula linked directly to a pivot table slow the calculations
down? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot tables
Hi,
The calculation of the pivot table or the calculation in the spreadsheet? Actually, I wouldn't expect a formula linked to the pivot table to slow things down onless there were thousands of them. But possibly if the formulas are of the =GETPIVOTDATA type rather than =G10, this formula can become extremely complex if you pivot table is complex, and in that case GETPIVOTDATA could be somewhat slower. What exactly is the formula and how many of them are their? -- Thanks, Shane Devenshire "froggey" wrote: Does having formula linked directly to a pivot table slow the calculations down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distributing Pivot Tables where pivot table data can't be accessed | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
