Excel User Defined Functions + Link.How to stop #Value after save

[Guest]

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?

 

[Bernard Liengme]

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

 

[Dave Peterson]

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]