View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Calculating cells cost hours

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 **