Problems with User-defined Function

[Victor]

It seems that everytime I save a workbook or change something in a
spreadsheet with user-defined functions, it starts re-calculating the
cells with user-defined functions. I can see this by looking at the
messages in the status bar. How can I prevent excel (2000) from doing
this? Also, the calculations are extremely slow? I don't know why
since the user-defined functions I defined are extremely simple and
short.

Victor

 

[Michael Malinsky]

I'm not sure, but I recall reading somewhere that UDFs generally work slower
then the built in functions. I'm assuming that it has something to do with
the UDF needing to be compiled before it runs.

In addition, if you have the workbook set to autocalc after each change,
each UDF will also recalc. As stated above, UDFs run slower so this may
take some additional time, especially if you have a lot of UDFs. One option
would be to turn off the autocalc feature and only calc the sheet when you
need to.

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh

 

[Victor]

I'm not sure, but I recall reading somewhere that UDFs generally work slower
then the built in functions. I'm assuming that it has something to do with
the UDF needing to be compiled before it runs.

In addition, if you have the workbook set to autocalc after each change,
each UDF will also recalc. As stated above, UDFs run slower so this may
take some additional time, especially if you have a lot of UDFs. One option
would be to turn off the autocalc feature and only calc the sheet when you
need to.

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh

Thanks! I think you've answer my question. I'll take on your suggestion.

Victor