View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default how can you freeze links in excel? no #Ref upon opening the file?

The INDIRECT functio cannot operate with unopened workbooks.

--
Best Regards,

Luke M
"Incognito" wrote in message
...
I have included quite some links in an excel file, however, upon opening
the
file, these links turn into #REF when the linked file is not opened; Is
there
any way to freeze the links?
--
Thx