Dear Excel(lent) users,

I have a problem with a particular file. The content of this file is 12 MB,
which might be the problem.

When I want to change a formula or make a new one it takes minutes to
calculate the cells. If i take a blank file and make the same formula it is a
matter of seconds.

What do I need to do, to make sure that the formula's and calculations take
no more than a matter of seconds??

Please this is taking my joy away !!

Thanks for your help !

--
** Fool on the hill **

You may have a big job. You need to examine the file and see where the
time-consuming calculations are and change the to be less process intensive.
This is not a quick-fix matter, and impossible for us to say from a
distance.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaydubs" wrote in message
...
Dear Excel(lent) users,

I have a problem with a particular file. The content of this file is 12
MB,
which might be the problem.

When I want to change a formula or make a new one it takes minutes to
calculate the cells. If i take a blank file and make the same formula it
is a
matter of seconds.

What do I need to do, to make sure that the formula's and calculations
take
no more than a matter of seconds??

Please this is taking my joy away !!

Thanks for your help !

--
** Fool on the hill **

Can I send the file to u?

It has 8 (out of ten) tabs in which calculations are made based on one tab
which contains Columns A through AE. In these columns I have entered mainly
data, but also some minor calculations and countif statements.
--
** Fool on the hill **


"Bob Phillips" wrote:

You may have a big job. You need to examine the file and see where the
time-consuming calculations are and change the to be less process intensive.
This is not a quick-fix matter, and impossible for us to say from a
distance.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaydubs" wrote in message
...
Dear Excel(lent) users,

I have a problem with a particular file. The content of this file is 12
MB,
which might be the problem.

When I want to change a formula or make a new one it takes minutes to
calculate the cells. If i take a blank file and make the same formula it
is a
matter of seconds.

What do I need to do, to make sure that the formula's and calculations
take
no more than a matter of seconds??

Please this is taking my joy away !!

Thanks for your help !

--
** Fool on the hill **

No, you can't. I do not have time to try and make a 12Mb file more
efficient, I have to earn a living.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaydubs" wrote in message
...
Can I send the file to u?

It has 8 (out of ten) tabs in which calculations are made based on one tab
which contains Columns A through AE. In these columns I have entered
mainly
data, but also some minor calculations and countif statements.
--
** Fool on the hill **


"Bob Phillips" wrote:

You may have a big job. You need to examine the file and see where the
time-consuming calculations are and change the to be less process
intensive.
This is not a quick-fix matter, and impossible for us to say from a
distance.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaydubs" wrote in message
...
Dear Excel(lent) users,

I have a problem with a particular file. The content of this file is
12
MB,
which might be the problem.

When I want to change a formula or make a new one it takes minutes to
calculate the cells. If i take a blank file and make the same formula
it
is a
matter of seconds.

What do I need to do, to make sure that the formula's and calculations
take
no more than a matter of seconds??

Please this is taking my joy away !!

Thanks for your help !

--
** Fool on the hill **

TURN OFF AUTO CALCULATE WHILE YOU ARE AMENDING FORMULAS, but remember to
turn it back on before you use your spreadsheet.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=564631