Recalculating block of cells
 

Daniel.

I think it might be wizer to review your formulas.
Generally sheets taking this long to compute have a few design
flaws. Fixing those may dramatically reduce calc times.
(my guess = under 1 minute per sheet)

If you want email me a zipped version to address below
I just may be able to solve the bottleneck(s).


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Daniel Bonallack" wrote:

I have a large Excel file that takes two and a half hours
to recalculate, and any one sheet can take up to 15
minutes to recalculate. Is there any way to recalculate
just a block of cells, or as anyone written a macro that
could do this?

Thanks
Daniel

Recalculating block of cells
 

That's a very kind offer. The file I'm working with is
90mgs, but if I can reduce it in size, I'll send it.

-----Original Message-----
Daniel.

I think it might be wizer to review your formulas.
Generally sheets taking this long to compute have a few
design
flaws. Fixing those may dramatically reduce calc times.
(my guess = under 1 minute per sheet)

If you want email me a zipped version to address below
I just may be able to solve the bottleneck(s).


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Daniel Bonallack" wrote:

I have a large Excel file that takes two and a half
hours
to recalculate, and any one sheet can take up to 15
minutes to recalculate. Is there any way to
recalculate
just a block of cells, or as anyone written a macro
that
could do this?

Thanks
Daniel



.

Recalculating block of cells
 

Compress it with WinRAR with option set to Maximum compression..
that generally brings it down to <10%.

Else rip out some data or duplicate sheets.
(but indicate what you ripped)

Mailbox accepts 3Mb. And have ftp with 10mb free.
Contact by mail pls.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Daniel Bonallack" wrote:

That's a very kind offer. The file I'm working with is
90mgs, but if I can reduce it in size, I'll send it.

-----Original Message-----
Daniel.

I think it might be wizer to review your formulas.
Generally sheets taking this long to compute have a few
design
flaws. Fixing those may dramatically reduce calc times.
(my guess = under 1 minute per sheet)

If you want email me a zipped version to address below
I just may be able to solve the bottleneck(s).


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Daniel Bonallack" wrote:

I have a large Excel file that takes two and a half
hours
to recalculate, and any one sheet can take up to 15
minutes to recalculate. Is there any way to
recalculate
just a block of cells, or as anyone written a macro
that
could do this?

Thanks
Daniel



.