Documentation / User FAQ / Calc / Previous-Next
Follow these steps:
Note: This is a global setting and will affect all spreadsheet charts and linked information from spreadsheets. If this is not desirable, click the checkbox next to On request. With this selected, a dialog box will pop up when each file with links to a spreadsheet is opened, where you can choose whether or not to update the item with newer information from the linked spreadsheet.
See also: How do I extend the range of data shown in my chart after I add new data to my spreadsheet?
Documentation / User FAQ / Calc / Previous-Next