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

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

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

--
HTH

Bob Phillips

"Jambruins" wrote in message
...
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

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"Jambruins" wrote in message
...
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

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

"bj" wrote:

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

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

"Jambruins" wrote in message
...
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