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. Linking in Spreadsheets is one-way, which means the links are only from Spreadsheets to Wdesk Documents, Presentations, and Workbooks. As a result, only blue source links exist in a Spreadsheet.
NOTE: At this time, linking into a spreadsheet is not supported.
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 Spreadsheets
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. Publishing pushes all the linked data from the spreadsheet to linked destinations and includes changes made by you and others.
There are two ways to see how many changes are unpublished and where they are:
NOTE: The orange change indicator does not appear in destination cells after updating source links cells in a spreadsheet.
To publish changes:
Click the Publish button to push all changes to destination links.
When there are changes from another user, you'll get a pop-up that lets you know there are changes from other users. Click Publish to continue.
Published changes appear in the document, workbook, or presentation.
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.