Your simplest solution would be to copy the UDF into a module in a workbox
you can take home.
Need help with VBA? See David McRitchie's site on "getting started" with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"DaveH" wrote in message
...
I have a Spreadsheet which Links to a file which is not always available.
Some functions return results from this file. I need to work at home. When
I
reopen my spreadsheet, I get #Values even though I say do not update
Links.

I know that it is not the link updating, but the worksheet recalculating.
Is
there a way to stop User Defined Functions from refreshing?