Updating Links to Graphics and Objects

Whenever you add an object to a spreadsheet as a link, such as a graphic file you want to update in the spreadsheet when the file changes, determine how the link is updated.

Automatically Updating Links

To have Calc automatically update links to files in a spreadsheet, choose Tools > Options > Spreadsheet > Other. Then select the Always option.

If you select On request, Calc prompts you to update the links whenever you open the document. If you select Never, Calc opens the document without updating the links, and you need to update them manually.

Manually Updating Links

If you don't have Calc set up to update links automatically, Choose Edit > Links. This menu option is available only if you've inserted an object in the spreadsheet by link. In the Edit Links window, select the link you want to update, and click the Update button.