Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
more than 3 conditions in conditional formatting - possible? rob curtis Excel Discussion (Misc queries) 11 August 17th 05 04:02 PM
Calculating Cells - Slower in Smaller File Diane Alsing Excel Discussion (Misc queries) 0 February 4th 05 04:17 PM
Calculating current age from 2 date cells dhealy Excel Worksheet Functions 1 January 19th 05 04:50 PM
CALCULATING CELLS AS A TOTAL EDDIE Excel Discussion (Misc queries) 4 December 23rd 04 03:27 PM
Calculating without including Hidden Cells LiquidFire Excel Discussion (Misc queries) 3 November 29th 04 08:35 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"