Dear all,
I have a file which has external links. I tried to make the named ranges in the source file as:
But this caused a problem: OFFSET does not support this, as it required the source file to be opened first before data from the named range can be fetched into a new file.Please Login or Register to view this content.
Then I searched online which said the INDEX function can overcome this problem. I tried again as this:
But this still showed error for the externally linked data if the source file is not opened first.Please Login or Register to view this content.
Is there anyway to get this to work?
Bookmarks