View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sue Sue is offline
external usenet poster
 
Posts: 285
Default problem updating links unless sources are open

I am trying to update a worksheet with external links and if the source to
those links are not open the spreadsheet returns a #value! error. Any
suggestions on how to fix this. I'm using Excel 2003.