VBA to calculate a larger size file part by part

[xlsvba87]

Hi all

I need your valuable expertise on my requirement. I have a file which is more than 50 Mb in size and linked to a reporting application. If I tried to Calculate the file, it takes more time and also it crashes. So I need a macro to calculate workbook based on the below order.
1) "Sheet Name 1"
2) "Sheet Name 2"
3) "Sheet Name 3" : "Range1" ( as this is bigger)
4) "Sheet Name 3" : "Range2"
5) "Sheet Name 3" : "Range3"
and so on.

Also there are certain sheets which need not to be calculated.

It would be really helpful if someone could come up with the solution for that.

Thanks in advance!!

 

[Chihiro]

It really depends on how formula dependencies are built in your sheet, as well as which version of Excel you are using.

Following links will give you detailed explanation with some examples.

http://www.decisionmodels.com/calcsecretsh.htm
http://www.decisionmodels.com/calcsecretsg.htm