Please Remove Cross-Sheet Reference Limit

Jessica Limke

I am currently trying to pull in data from multiple different sheets into 1 summary view sheet and hit the 100 unique cross-reference max limit, and I am not even halfway finished with my task. Can this limit please be removed or at the very least increased to a much larger number?

Paul Newcome

@Jessica LimkeYou can use a helper column in the source sheet to combine the multiple columns across each row into a single string (with a unique delimiter), pull this string over to the target sheet, then use a parsing solution to pull the individual data pieces out of the combined string. This will also help with sheet performance since cross sheet references can have a big impact on that.

Jubial

Second this - I've had many sheets completely break on me due to this. :(