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
Answers
-
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.
-
Thanks @Paul Newcome I think we may have to delete the references and take it from there.
Appreciate your feedback.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives