View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerardo Gerardo is offline
external usenet poster
 
Posts: 27
Default links to a second workbook doesn't work if origin not open

I have some links from one workbook to another, but when I open only the
destination workbook the link shows #value! error. If I then open the origin,
the link does show the proper value. If I close the origin, the link keeps
the values in destination just during that "session" if I close the workbook
and open again I will need to open the origin as well. Why the link doesn't
keep the values as it should?