Thread: substitute the filename in a cell reference with a string in another cell.
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default substitute the filename in a cell reference with a string in another cell.
Hans,

I think it has to do with the file being closed. If you insert INDIRECT
while the referenced file is open it will display correctly 904. If you
close it nothing will change until recalculation takes place. Try it
and let me know.

Kostis

Reply With QuoteReply With Quote