How to identify the unknown sheet

Tamsyn

Hi there,

I am an admin on our company SS account.

One of our automation is not working, we think because there are too many formulas being used to reference on of our sheets.

Can anyone advise how to find out which sheet a range reference is set from as an administrator?

Thanks in advance

Paul Newcome

There is no way to determine this without already having access to the sheet that is referencing yours.

The only thing you can do would be to delete the reference from that other sheet and wait until someone reaches out about their sheet being broken.

Tamsyn

Thanks @Paul Newcome I think we may have to delete the references and take it from there.

Appreciate your feedback.