Viewing all Links in a Spreadsheet
已回答How can I see all links that are in spreadsheets? I want to be able to find where a link is going to a document so I can delete it, but I don't want to have to go link by link to find it.
-
Hi Becky!
Great question. I think I have a solution for you.
The best way to do this is in two parts. Here are the steps.
- Run the Linked Files Report on the Spreadsheet in question. This is done from Home by right-clicking on the file and choosing Linked Files Report. Here are some steps on our Help site as well: https://support.workiva.com/hc/en-us/articles/360036000671-Use-the-Linked-Files-Report.
This will run in the background and send you a notification when its done. Once it's done, you can move onto step 2.
- Next, from the opened Linked Files Report, choose the option for Create Spreadsheet of File Links option. This will generate a new file that shows all the links to and from your file.
This report will out all the links, their section and location, what type they are (source or destination), if they are published or not, as well as hyperlinks to go directly to them. This report also comes pre-populated with filters too, so you can find what you are looking for.
Hopefully this helps some. Do let me know what questions you have on any of the above, or if you need any additional guidance. Thanks again and have a happy holiday season!
0请先登录再写评论。
- Run the Linked Files Report on the Spreadsheet in question. This is done from Home by right-clicking on the file and choosing Linked Files Report. Here are some steps on our Help site as well: https://support.workiva.com/hc/en-us/articles/360036000671-Use-the-Linked-Files-Report.
评论
1 条评论