Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
Calculating Cells - Slower in Smaller File | Excel Discussion (Misc queries) | |||
Calculating current age from 2 date cells | Excel Worksheet Functions | |||
CALCULATING CELLS AS A TOTAL | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |