Link from a spreadsheet to other Wdesk files to share data and keep it consistent across all documents. Use the Publish feature to push your changes, as well as any changes made by others, from source cells to the destination links.
Linking from Spreadsheets
Once you have your Spreadsheet set up, you can link to other documents in Wdesk.
To create a link from a spreadsheet:
Select the cell and use your keyboard or right-click to Copy and Paste into a destination cell or text in a document, workbook, or presentation.
From the clipboard, select Create Links from and choose the appropriate option.
If you change a linked value in the spreadsheet, the orange indicator appears to show the change is unpublished.
Publishing Your Links
When you first create a link, Wdesk automatically publishes that change. You must click Publish for any changes you make after creating the initial links.
By default, publishing in Spreadsheets will publish only link changes made by you. If you are a document owner, you can also choose to publish all pending link changes in your spreadsheet.
Sheets will have different indicators depending on whether changes were made by you or another contributor.
A) Sheets with pending changes from you will have a solid gray triangle indicator in the outline.
B) Sheets with pending changes from other contributors will have a gray triangle indicator with an underline
Cells with pending changes will have a blue indicator with a red underline.
Clicking the Publish button will share your pending links and update any references to that link, such as formulas. Link changes from other users will not be affected.
When there are changes by collaborators that impact a formula, publishing includes your changes, impacted formulas, and changes collaborators made that impacted that formula. This ensures formulas are accurate across linked documents.
The publisher can see whose changes were released by clicking the notification in the bottom right, and anyone whose changes were published this way will receive a notification in the bottom right.
Publishing All Links
Document owners can choose to publish all pendings links at once. This will publish all pending link changes from all users and cannot be undone.
Open the dropdown next to the publish button and choose Publish All Links. Confirm your choice to publish all pending link changes.
Editors can be allowed to publish all links if the document owner enables the option in Spreadsheet properties.
View Link History for a history of changes to links in your spreadsheet. For more information, see Collaboration in Spreadsheets.
To compare revisions, create a blackline of a linked document to compare changes that originate from a spreadsheet. For more information, see Document Blacklines.