Linking to a Data Range in a Spreadsheet
LO5 :: To be able to select and present information in the development of the solution to meet an identified need
If you need to show some specific data in a spreadsheet it might be better to to link to the cells that contain the data rather than the whole spreadsheet.
Open the document and the spreadsheet file together. You might want to have both windows open side by side you your screen.
In the spreadsheet file select the area to be linked and right-click and choose Copy.
Now go to the document and select where you would like the data inserted. Right-click then choose either of the Paste Link options from the pop-up menu.
When you change some of the data in the spreadsheet file, it will be automatically updated in the document at the same time. You can also press F9 to refresh your data at any time.