Sheet limits and column formulas
Sheet limits suggest 100,000 cross sheet referenced cells
Does a column formula (referencing a single cell on another sheet) count as a single cross reference or is it multiplied by the number of rows on the inbound sheet?
Also, are these limits strictly sheet limits, or will the limitations cascade to other sheets? For example, if sheet "A" references 11 "B" sheets via 11 cells, and each "B" sheet references "C" sheets via 10,000 cells each, will sheet "A" be able to to this on not because ultimately, 110,000 references are at the end of the chain?
Or is it ok, because no single sheet exceeded the 100,000 limit?