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

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?

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

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?

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

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

DaveH wrote:

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?

--

Dave Peterson