Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
recalculation not recalculating some cells containing user functio | Excel Discussion (Misc queries) | |||
Block time cells | Excel Discussion (Misc queries) | |||
BLOCK CELLS FROM BEING EDITED | Excel Discussion (Misc queries) | |||
Hiding a block of cells | Excel Discussion (Misc queries) | |||
Recalculating Cells error (and more) | Excel Programming |