Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Document Links Report - Destination List

Con risposta
Request Demo

The scenario:
I have Workbook A, and it is the source feeding into separate workbooks C and D, as well as presentations E and F. I believe it is also the source to some other unknown workbooks/presentations/documents, X and Y, which other people have set up.

The ask:
I would to get a list from Workbook A giving me all the destinations that its data is linked to.

The Document Links Report is useful for sources of data for the workbook, giving source workbook and location, but does not give any details relating to destination links - it only serves up a hyperlink to workbook cells, which is not practical when handling thousands of links.

In order to maintain the workbook, I need to be clear which other files any changes may impact, but as it is, I am completely in the dark. Is there any other way to get a list of all the destinations for a workbook?

0

Commenti

4 commenti

Data Voti
  • Isabel Messore

    Hi Peter Wetheridge,

    It sounds like you would like to run a Link Files Report on the source spreadsheet. This LFR will compile the full network of documents linked to the source spreadsheet in question. Here is our support article for more information!

     
     
     
    1
  • Peter Wetheridge
    • Modificato

    Thanks Isabel Messore - this definitely helps - it doesn't list every destination, link by link, but I can at least see which files are connected.

    Just looking at my report and under the 'Additional FIles' section, I see a lot of referenced files with both Outside Sources 'none' and Already Included 'none'. Do you happen to know this means? Why would they be listed if there is no active relationship?


    * edit - typos

    0
  • Isabel Messore

    Peter Wetheridge,

    That is odd. I don’t think that’s expected behavior, but I may be forgetting a case that could produce this. Let me experiment for a bit to try to reproduce this. If I fail in that attempt we'll get a Support ticket drummed up for you so we can investigate further!
    0
  • Isabel Messore

    Update for you Peter Wetheridge,

    I can’t figure out how to reproduce and I don’t believe we would expect this state. If a document appears in the “additional linked files list” as a “destination” relationship it should have at least one source file/link in either the “outside sources” or “already included” category. So, I'll get a support ticket started for you and our team will be in touch!

    0

Accedi per aggiungere un commento.