Excel locks up when using the SaveAs feature...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top