Link to linked spreadsheet not updating

This is handy if you have a very long formula because it enables you to “break up” the formula so that it appears on multiple lines.To create a line break within a formula, press Alt Enter.

If you then alter in anyway such as workbook name or sheet name, then when tries to update itself with the new data it cannot be found because the referenced name has changed.As the source files are changed, the destination workbook should also be updated.Microsoft Excel 2007 enables you to update links automatically as you open any workbook.With manual links, Word updates the links only when you decide to update them. The simplest is to position the cursor somewhere in the linked object and then press F9.The other is to choose Linked Worksheet Object - Links...There may be times when you need to update the links manually, however.