Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes range calculate doesn't work in macro. Why?
I have applications in active use in my company that under macro control
just calculate a single cell, or a range. I figure that I don't need to calculate the entire workbook when I don't need to. Usually this works fine. Every once in a while it doesn't. Once a workbook gets into such a state the only solution is to delete the range and do a calculate on the entire workbook. The one I saw today, and which motivated me to post, there was no other workbook open. Have others seen this? Any idea why? We are using xl2002. Don <donwiss at panix.com. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes range calculate doesn't work in macro. Why?
Hi Don,
There are several known limitations of Range.calculate with Excel 2002. Maybe you have hit one of them: see http://www.DecisionModels.com/calcsecretsg.htm Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Don Wiss" wrote in message ... I have applications in active use in my company that under macro control just calculate a single cell, or a range. I figure that I don't need to calculate the entire workbook when I don't need to. Usually this works fine. Every once in a while it doesn't. Once a workbook gets into such a state the only solution is to delete the range and do a calculate on the entire workbook. The one I saw today, and which motivated me to post, there was no other workbook open. Have others seen this? Any idea why? We are using xl2002. Don <donwiss at panix.com. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes range calculate doesn't work in macro. Why?
I have many VBA macros that do the same range calculation. I have found that
in EXCEL versions 2000 and lower the macros work fine. In versions 2002 and higher, the range calculation code generates a error code 1004 if calculation is set to manual and if iterations are set. As long as the range you need to calculate does not contain circular references then you can fix the problem by turning off iterations. "Don Wiss" wrote: I have applications in active use in my company that under macro control just calculate a single cell, or a range. I figure that I don't need to calculate the entire workbook when I don't need to. Usually this works fine. Every once in a while it doesn't. Once a workbook gets into such a state the only solution is to delete the range and do a calculate on the entire workbook. The one I saw today, and which motivated me to post, there was no other workbook open. Have others seen this? Any idea why? We are using xl2002. Don <donwiss at panix.com. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sometimes range calculate doesn't work in macro. Why?
I have many VBA macros that do the same range calculation. I have found that
in EXCEL versions 2000 and lower the macros work fine. In versions 2002 and higher, the range calculation code generates a error code 1004 if calculation is set to manual and if iterations are set. As long as the range you need to calculate does not contain circular references then you can fix the problem by turning off iterations. "Don Wiss" wrote: I have applications in active use in my company that under macro control just calculate a single cell, or a range. I figure that I don't need to calculate the entire workbook when I don't need to. Usually this works fine. Every once in a while it doesn't. Once a workbook gets into such a state the only solution is to delete the range and do a calculate on the entire workbook. The one I saw today, and which motivated me to post, there was no other workbook open. Have others seen this? Any idea why? We are using xl2002. Don <donwiss at panix.com. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
Create macro to calculate data range for a running chart | Excel Worksheet Functions | |||
TO TOM OR KEN: macro to calculate selected range | Excel Programming | |||
Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range | Excel Programming | |||
Macro that hide or unhide and not calculate or calculate | Excel Programming |