Current data is more important than past data.
yes
The benefit of linking a chart from an Excel worksheet to a Word document is that the chart data will always be current. Excel is spreadsheet software from Microsoft.
A link in Excel can be like a link on a webpage. By clicking on it, it can enable you to jump to different parts of the worksheet, different parts of the workbook, to a different workbook, to another kind of file and to a webpage. Another type of link is where data in one workbook is linked to data in another workbook or other kind of document. When data is updated in one, it will also change in the other document, as it is looking at data it is linked to.
To quickly determine if spreadsheet data in a Word document is linked to a source file, right-click on the data and choose "Linked Worksheet Object" or "Linked Excel Chart" if available. If the option to "Edit Links" appears, it indicates that the data is linked to an external file. Additionally, you may see the "Update Link" prompt when opening the document, which further confirms the data’s linked status.
Normally it will update automatically. If it is linked into another document, it may have to wait until it is that document is opened before updating.
True
Is an external excel spreadsheet linked into a word document considered a compoound document in the microsoft enviroment?
The data will be in its original form, but any changes in the data will be reflected in the Excel document, as will changing the Excel document affect the Access table. It is the same data when it is linked, not copied.
A Word doc with a linked spreadsheet is usually called a 'Compound Document'.
It is still an Excel spreadsheet. The workbook does not change, just because it is linked to another document to form a compound document.
Sure. Why not?
yes