P
partha
Hi,
I have an excel worksheet that has a lot of
calculations that have been calculated using User Defined
Functions (UDF's). The UDF's work fine and I get all the
right answers. But when I try to save a copy of the
worksheet using the SaveAs feature, Excel locks up. When I
press Esc. and try to debug it, it shows up some random
error in one of the functions in the VBA editor. This
particular function has some pretty heavy calculations
(iterative calculations). I am pretty sure that there is
no problem with the code (since I got the correct answer
when I used the function). This particular function has
many inputs(including arrays as inputs). Is it the case
that excel is unable to do such heavy calculations. (I
have the Automatic option checked in the Calculations
field Options->Calculations->Automatic).
Could someone help me with this?
Thanks,
Partha
I have an excel worksheet that has a lot of
calculations that have been calculated using User Defined
Functions (UDF's). The UDF's work fine and I get all the
right answers. But when I try to save a copy of the
worksheet using the SaveAs feature, Excel locks up. When I
press Esc. and try to debug it, it shows up some random
error in one of the functions in the VBA editor. This
particular function has some pretty heavy calculations
(iterative calculations). I am pretty sure that there is
no problem with the code (since I got the correct answer
when I used the function). This particular function has
many inputs(including arrays as inputs). Is it the case
that excel is unable to do such heavy calculations. (I
have the Automatic option checked in the Calculations
field Options->Calculations->Automatic).
Could someone help me with this?
Thanks,
Partha