low speed problem
 

Hi guys,
I'm working with an Excel file consisting of 8 worksheets, each one having
an average rows of 6000.I'm applying many regular formulas, array formulas
but no macros or function and concequently the speed of calculation is too
low and kinda boring.THE iTERATION SETTING FOR MY EXCEL IS:
MAX. ITERATION :100
MAX. CHANGE :0.001
and my systems specs a
Pentium(R) D CPU 3.00 GHz
2.99 GHz 504 MB RAM
HARD 150 GB
I was wondering if you guys know how I can speed up the calculations in my
file!!
thanx in advance

low speed problem
 

As a guess you have surpassed the smart calc limit of 65k dependancies so
that your spreadsheet requires a full call every time... Check out this
link...


http://www.decisionmodels.com/calcsecretsf.htm

That site has a lot of other good info in increasing speed, memory issues
and such...
--
HTH...

Jim Thomlinson


"peyman" wrote:

Hi guys,
I'm working with an Excel file consisting of 8 worksheets, each one having
an average rows of 6000.I'm applying many regular formulas, array formulas
but no macros or function and concequently the speed of calculation is too
low and kinda boring.THE iTERATION SETTING FOR MY EXCEL IS:
MAX. ITERATION :100
MAX. CHANGE :0.001
and my systems specs a
Pentium(R) D CPU 3.00 GHz
2.99 GHz 504 MB RAM
HARD 150 GB
I was wondering if you guys know how I can speed up the calculations in my
file!!
thanx in advance

low speed problem
 

Yo Jim! Just want to say thanks for that cool link.
--
Kevin Backmann


"Jim Thomlinson" wrote:

As a guess you have surpassed the smart calc limit of 65k dependancies so
that your spreadsheet requires a full call every time... Check out this
link...


http://www.decisionmodels.com/calcsecretsf.htm

That site has a lot of other good info in increasing speed, memory issues
and such...
--
HTH...

Jim Thomlinson


"peyman" wrote:

Hi guys,
I'm working with an Excel file consisting of 8 worksheets, each one having
an average rows of 6000.I'm applying many regular formulas, array formulas
but no macros or function and concequently the speed of calculation is too
low and kinda boring.THE iTERATION SETTING FOR MY EXCEL IS:
MAX. ITERATION :100
MAX. CHANGE :0.001
and my systems specs a
Pentium(R) D CPU 3.00 GHz
2.99 GHz 504 MB RAM
HARD 150 GB
I was wondering if you guys know how I can speed up the calculations in my
file!!
thanx in advance

low speed problem
 

What version of Excel?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"peyman" wrote in message
...
Hi guys,
I'm working with an Excel file consisting of 8 worksheets, each one having
an average rows of 6000.I'm applying many regular formulas, array formulas
but no macros or function and concequently the speed of calculation is too
low and kinda boring.THE iTERATION SETTING FOR MY EXCEL IS:
MAX. ITERATION :100
MAX. CHANGE :0.001
and my systems specs a
Pentium(R) D CPU 3.00 GHz
2.99 GHz 504 MB RAM
HARD 150 GB
I was wondering if you guys know how I can speed up the calculations in my
file!!
thanx in advance