S
Svea
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
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