Outbound Cell Limit?

Margaret Wood

I'm curious to know if there is a limit to the number of times cells can be referenced from a sheet (source). Say, if you have a source sheet 2500 rows, and you need to reference a pair of columns from that sheet on 30 other sheets (so 2500*2*30=150000), is there ever a limit reached? Or is the limit only in regards to the destination sheet?

Thanks!

Genevieve P.

Hi @Margaret Wood

Yes, there is an outbound cell limit of 25-million. This includes cross-sheet references, in-sheet cell references, column references, and range references.

Cheers!

Genevieve

Paul Newcome

Everything I have seen is based on the destination sheet.

@Andrée Starå @Genevieve @Mike Wilday Any info? Am I able to link a cell to 1,000,000 different sheets as long as those other sheets don't exceed the other limits?

Genevieve P.

Hi @Margaret Wood

Yes, there is an outbound cell limit of 25-million. This includes cross-sheet references, in-sheet cell references, column references, and range references.

Cheers!

Genevieve

Paul Newcome

Thanks @Genevieve P! That's quite a bit!

Margaret Wood

Wow! So while not impossible to achieve, very unlikely unless you've got quite a large project. Thanks for the answer!

Andrée Starå

@Paul Newcome @Genevieve P @Mike Wilday @Margaret Wood

https://media.giphy.com/media/LPrAK9rEedDwjtL1J0/giphy.gif

Paul Newcome

Hahaha. @Andrée Starå You would be the one to accomplish it.

Mike Wilday

@Paul Newcome @Andrée Starå Where there is a will. There's a way.

#MyMotto #PressEveryLimit