Cross Sheet Reference Limit

Enfield Homes

Hi guys,

Can anyone tell me if the same referenced field is used in more than one formula, is the reference counted as 1?

I've mixed out my references and wondered if there's a way to reduce the number of unique connections.

Kleerfyre

I don't think it is. Try right clicking on a cell with a reference in it and then click on the option Manage References. You should see all your cross sheet references there and can see what you can adjust to get under the limit.