Is there a way to...(calculation question)

[Guest]

I have 33 sheets with many equations on each sheet. 29 of the sheets only
need to be updated once a day. The other 4 sheets I am updating quite often
during the day. Is there a way to have the formulas on the 29 sheets update
once and then not have excel keep updating them. It takes a while to update
them all and I don't want to wait for it to do it. Anyone know a way to do
this or some way to speed up the process? Thanks

 

[Bob Phillips]

You could turn calculation off in the Workbook_Open code, and on in the
workbook_beforeclose event.

 

[Guest]

You could also make calculation manual in the options calculation and use
shift F9 to only claculation the active worksheet but F( to redo the entire
workbook

 

[Guest]

thanks bob and bj, that will work great! Thanks for the help