View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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