Description: Edit "Links to External Files..." Shows: Source File, Element, Type, Status, but it doesn't show from where is requested. Some times the Source File Link is called by a formula where the "file:///" or any other way to call for a File link is not Stated, because it might be called by an "indirect()" formula. You can Break the Link as many times as you want, but every time that you open the file again, it will call it again, because is in a formula in the file. It would be "nice" to be able to find All or at least the first call of the File Link. It happens to me in Calc, but I guess is the same on all the components Steps to Reproduce: 1.Link a file to a document 2. Go to "Edit "Links to External Files..."" look for the source of the Link File 3. Try to find it from the Edit Links Actual Results: Shows the sourced file Expected Results: Would like it to also show From where the Link was called. To sometimes, try to fix the link Reproducible: Always User Profile Reset: No Additional Info: Have an option to show from where the link was called, or just show the firs occurrence
Created attachment 178155 [details] Edit -Links to External Files -Edit Links -Source Cell Unknow On the Error Message, it shows some kind of description, indescifrable, but also would be good if it showed from where the Link to external file is called. On the Edit Links window, it shows columns: "Source file", "Element", "Type", "Status" On those columns it could be added something like "First Call" with some description like "Sheet1:B5" You have the option to "Modify..." "Break Link" "Update" "Close" It should be added and option to request to show "All" the calls to the Linked file/s.
Created attachment 178559 [details] Shows the "Edit Links" screen, no option to find cell "from where" the request was made On the Edit Links screen, you have the option to see the Source File (from where is the requesting link taking the data). But there is no option to see "From Where" the request was done. From wich cell is this request coming? It might have one request or hundreds, but there is no way to know "from where" that call was made. It would be good to have a way to "List" from wich cells the calls were made. On the screen shot you can see a Source File named "3", but in the same screen is supposed to show the Full Source Path with the full file name including the extension. On that section it only shows "3" with no Path and no extension, just "3". I'm looking for a way to find from where is that file called, and get rid of it. Somewhere in the Sheet is a "wrong" call that I would like to find and discard. It would be nice to have, also for troubleshooting and improving the sheet "coding".
Thanks for the suggestion. I was trying to recreate an example file but couldn't (I could always break the link). Could you please attach a sample file? Thank you!