Updating excel links
Microsoft will display a Security Alert similar to the image below, warning that if you enable automatic update of links, your computer may no longer be secure.
Assuming there actually is no risk, and to allow the link process to proceed, click the radio button by "Enable this content" and click OK.
To fix this, you can either update the broken link, or remove it.
Microsoft Excel provides the ability for cells in one worksheet to be linked to cells in other worksheets in the same or different workbook.
In the example below, using Method Two, we click in cell B6 in the source worksheet and click Copy.Then, on the destination worksheet, we click in cell B3, and paste the link. (Note: Excel automatically wraps worksheet names C or R in single quotes.) If the worksheets are in different workbooks in the same folder, the formula will also need to contain the workbook name in brackets: .(File extension of xls for Excel versions older than Excel 2007.) And if the workbooks are in different folders, the formula would have to include the complete file path as well, so it is best to avoid manual formulas in this situation.If another user has changed a value in a cell, Microsoft Office Excel does not look for the new value unless you tell it to.To update the links, on the Trust Bar, click Options, and then click Enable this Content.