Offset with a link

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Using the offset function with a link to another workbook
works great until I close the workbooks and reopen the
workbook with the offset functions with links, which
gives #VALUE! for those cells. Using Excel 2002 - help
would be welcome.
 
Then you have discovered that offset won't work unless link and linked
workbooks are open
 
Ok. What is the alternative for getting the same result
as the offset function? I want to link to a number of
workbooks without opening them all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OFFSET Function 1
Mapping integers to strings 5
Links to 2nd closed worksheet fail when using offset function ?? 1
relative offset to a named cell 3
Offset/match returns #value error 8
OFFSET with a condition 0
Error in Function OFFSET 5
named range in sum formula (indirect, offset, worksheet name) 4

Back
Top