View Single Post
  #1   Report Post  
Svea
 
Posts: n/a
Default Calculating cells... lasts so long


Dear friends,

Please help me with following, it is very important. I have a very huge
table containing many formulas and calculations. I needed to spread
formulas till 500th row.

Of course, many data are linked to other sheet, etc.

So when I enter something... Excel starts Calculating cells (lower left
corner), and then...
10%.....................15%....................... ......................30%....
etc
It lasts too long.

I know that I can turn off automatic calculation, but it is not
solution I want.
Can I solve it on some other way? For example, that Excel calculate
only the row in which I am momentarily entering numers, dates,
amounts....

Thanks


--
Svea
------------------------------------------------------------------------
Svea's Profile: http://www.excelforum.com/member.php...o&userid=28151
View this thread: http://www.excelforum.com/showthread...hreadid=481025