Link to Unknown Sheet

scott.barrett

We are experiencing issues with "links to unknown sheets" popping up. See image attached.

We are saving the sheet that the link is going to as a new sheet (almost like using it as a back up), but we are clicking so that the "links do not carry over", so it should not be happening from this task.
We have no way of where the link is trying to read, since it is unknown. So, we don't know what task is causing this.
We do not think anyone else is accidentally saving as new, but it is odd that anyone with viewer access can save as new.

Any ideas?

Scott

Link Unknown Sheet.jpeg

Find more posts tagged with

Forms

Construction

Sheets

Sharing and Collaboration

Security

Support

IT & Operations

Cell linking

Comments

J. Craig Williams

This is related to either:

1. The sheet being deleted

2. The sheet's permissions being changed (possibly by moving it)

There is a related open issue that the developers are working on. I'm told they are hoping it will be in the next release (March)

If this just happened, check your Deleted Items folder for any Sheets that may be a possible source of the error. Owner of the workspace will have the item in their Deleted Items folder, regardless of whether they deleted it or not.

To check for the second, ask colleagues to check for connection too or if they may have done something to cause it.

In addition, after you perform the Save As New operation, wait 2 hours, make some small change to the sheet (anything that requires a Save), and then save it.

Craig

J. Craig Williams

See images.

When the mouse is hovered over the popup and over the <unknown sheet> line, a "delete" option appears.

I don't know if that is new and if so, how new, but it will remove at least one type of link to <unknown sheet>

Craig

Kirstine

This isn't working for me.

I get the delete option when I hover on the 'Used in formula on' (which I want to keep!), but when I hover over the 'Sheet' part I get nothing...!

Am I doing it wrong?

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…