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

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?