| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to increase calculations speed in pivot table with calculated fields & items
Hi All
I have a budget constructed in a form of pivot table with added calculated fields actual vs budget, differences, % of completion and calculated items in row area that group some accounts and calculate profit, EBIT. When i dragging the acc items in row area or turn off or on additional fields in column area table starts to calculate formulas ant it takes about 3-5 min to coplete refreshing. how can I increase this process or refresh pivot manually? turning off option SAVE DATA WITH TABLE LAYOFF in table options doesn't work here. Source data have about 20k of rows only... If anybody could give some advis about this - i'll be appreciate. Thanx Stanislav |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Help with pivot calculated fields? | Excel Discussion (Misc queries) | |||
| How to "blank" pivot table calculated fields if result = 0 | Excel Worksheet Functions | |||
| PIVOT TABLE - hiding records with CALCULATED item values equal to | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
