Make Office Better
Top tips for the best office programs
ONLYOFFICE
Make spreadsheets automatically update linked data
You can keep a spreadsheet relevant by manually updating the ‘linked’ data it shows. This is data that’s pulled from other sources, such as a budget spreadsheet that gets spending details from separate files for groceries, utilities, entertainment and so on.
Rather than manually updating this data, you can set your spreadsheet to do so automatically – without you having to do anything. OnlyOffice added this option in version 8.3, released in January. Open your spreadsheet, then click the Data tab at the top followed by External Links ( 1 in our screenshot). Now tick ‘Automatically update data from the linked sources’ 2 , then click Close.