Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about financial calculation PMT | Excel Worksheet Functions | |||
Calculation question | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Calculation Question | Excel Worksheet Functions |