Re: Calculation time

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes, in a manner such that a partial formula is only effected once by a
calculation, and if the result doesn't change, all its dependent cells
aren't recalculated.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"BKO" <BKO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF9442E6-C760-41D5-9E07-29B9F672F75E@xxxxxxxxxxxxxxxx

I don't know if I understand everyting right,

So to decrease the calculation time it is better to split the formula's up
in more cells, in stead of using a complex formula (and get a direct
result),

I already use dynamic ranges, but it seems to make no difference.

It is not possible for me to use sorted ranges,

Are there any other tips to decrease the calculation time

Thanks for the info so far



--
There are only 10 types of people in the world:
Those who understand binary and those who don''''t.



"bj" wrote:

When there are too many dependencies, every cell gets recalculated
whether it
is in a dependency list or not.

Macro functions can be used to reduce the effective number of
dependencies.
(they can also increase the dependencies when done wrong)

"Bob Phillips" wrote:

Excel only calculates a certain number of cells, any that change, or
are
dependent upon cells that change.

To reduce the calculation times, you need to be smart, reduce the
number of
cells dependent upon a change.

There are some hints and tips at
http://www.decisionmodels.com/calcsecrets.htm

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"BKO" <BKO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC7C0250-66BF-45EE-AC5B-03A13D86B0C8@xxxxxxxxxxxxxxxx
Hello,
I have a large data file (10.000 rows / 10 columns) from wich I have
to
process data. I use a lot of index match formula's, lookup tables
and
data
validations, in multiple sheets

Now the calculation of the sheet takes about 25 seconds after each
input.

How can I speed up the calculation time, or calculate only the cells
that
are actualy changed after input.

Any help or information about this matter would be appreciated very
much,

Thanks in advance


--

There are only 10 types of people in the world:
Those who understand binary and those who don''t.






.

Relevant Pages

  • Re: Match, Filter????
    ... This formula will work but it will add to the calculation time that you ... I need to average cells A1:A100 where the corresponding cells in B1:B100 ...
    (microsoft.public.excel.misc)
  • Round Len Function Help
    ... dependent on another cells content. ... of Q16 and change the 0.007 to either up or down depending on ... the calculation. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: What is smart recalculation limits?
    ... Can you give an example of the contents of your cells, and the formulae that you are using in these 50,000 cells. ... Does Excel 2003 use full calculation? ... dependent on a single area and 64,000 areas having dependencies. ...
    (microsoft.public.excel.misc)
  • Re: Recalculating a spreadsheet in multil-processor environment - design pattern?
    ... I have a collection of cells (actually individual objects in my ... The calculation time can be relatively long, ... constant values) goes on a queue. ... A cycle corresponds to a recursive ...
    (comp.programming)
  • Re: Function/Procedure dependence & order of execution
    ... every function1 dependent on something1 and every function2 dependent on ... > My spreadsheet has a Procedure that creates an array of data locations. ... > worksheet Function1 uses this array to perform it's calculation. ... > Function2 are used in many different cells. ...
    (microsoft.public.excel.programming)