Link count and Ranges - Does each column in a range count as a link?
After reading up on the issue of cross sheet link limits, I would like to confirm what 'counts'.
If a range is defined as having 10 columns does that count at 1 link or 10?
If a range has 20 columns is that 20 links or one?
And finally if that same range is used for several VLOOKUP functions in a destination sheet, does each use of the VLOOKUP (with a different return column number) count as a link?
Help Article Resources
Check out the Formula Handbook template!