View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daveh Daveh is offline
external usenet poster
 
Posts: 30
Default 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?