Managing (deleting) cross sheet references

Mike L.

If sheet A contains 5 unique cross sheet references (each filled down through 1000 rows) in order to look up values on the master sheet and I delete all of the rows in sheet A, does that also delete (free up) those 5000 previously used cross sheet references?  Thanks!

J. Craig Williams

There should be no impact unless you have crossed the 25k limit and then need to wait for the system to catch up.

But in my (limited) testing, yes.

Craig

 

Mike L.

Craig, thanks so much for your comments.  I must say I seem to have a mental block about the 25K limit. Does this mean that you are limited to 25K inbound formulas? Or can you have more than 25K inbound formulas requesting data but only 25K cells in the reference sheet can have formulas pointing to them. 

• There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total, 

Thanks, Mike