How to increase calculations speed in pivot table with calculated fields & items

S

stas.konovalov

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slicers and Calculated Items in Pivot Table 2
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
Pivot Table calculated item 4
"Dynamic" calculated fields in a pivot table 0
Using a Count'ed field in a Calculated Formula for a Pivot Table 0
Pivot table and calculated fields 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1

Top