I would like to ask the community on how the 100,000 inbound cell cross sheet reference is computed.
Using the following example:
If I have a sheet with 10 columns and 100 rows, and 2 column level formulas using index/match cross-references to the same (or different) sheets, then my current inbound cells count is 2 *100=200. Is this correct?
- Each sheet can include no more than 100 distinct cross-sheet references.
- There’s a limit of 100,000 inbound cells that can be referenced from other sheets into one sheet in total.