2. How does the data get refreshed between
linked workbook when the destination
workbooks are closed?
Answer plzzz......
Answers
Workbooks can contain links to other OLE compatible applications, such as Reuters and Bloomberg.
You can prevent updating these links accidentally by locking the links.
Select (Tools > Options)(Calculation tab) Remove the check mark in the Update Remote References box.
If you want a worksheet to always display the same data as another you can link the data.
You can easily create links between your workbooks and between your worksheets
This way if you change the data in the original worksheet, the data in the linked worksheet will also change.
Links are created using formulas and have this format: "=[Book4]Sheet1!$A$2"
If you want to update the links after a workbook has been opened you can use the (Edit > Links) dialog box.
If the workbook does not contain any external links, then the (Edit > Links) command will be disabled.
The workbook that contains the formula is called the "dependent" workbook and the workbooks that contains the data being referenced is the "source" workbook.
If the values in the source workbook change, the formula that references them can update its results automatically.
If the source workbook is open when you open the dependent workbook, the formulas are automatically updated without any prompt.
If the source workbook is closed when you open the dependent workbook you will be asked if you want to update the linked information
Update - will update all the formulas containing external references.
Don't Update - the formulas are not updated and keep their current values.
This will only be enabled if your workbook contains links to external sources or other workbooks
When you open a workbook that contains one or more links to other workbooks you will be prompted and asked if you want to update those links.
You will only be prompted if one or more of the source workbooks is closed, if they are all open, then the links will be updated automatically.