Excel 2007 do not update external links

Any ideas? Thanks again! Office Office Exchange Server. Not an IT pro? Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Asked by:. Archived Forums. Excel IT Pro Discussions. The source workbooks are Exports from Crystal Reports, could that have anything to do with it? Re: Links won't update unless files are actually opened The export file from Crystal Reports, is it an Excel file? I think if it's not an Excel file, it wouldn't recognize the cell structure until opened.

Re: Links won't update unless files are actually opened The export file is an excel worsksheet the result of a Crystal Reports export to excel , and it has an.

Re: Links won't update unless files are actually opened My only guess is that the export file is not the exact proper excel format even though it has an. How about opening one of the exported files, and save it over as type Microsoft Office Excel Workbook with the same name. Then close that export file and open your summary report file to see if it would update.

If that doesn't work I don't really know what else to recommend. Re: Links won't update unless files are actually opened Simon, Believe it or not, simply opening the exported file then saving it without renaming or otherwise manipulating anything yields the expected result. Also please visit my website www. Your email address will not be published.

Contents Why Does it Appear? Tagged with: Excel , Links , Security. This option is useful when you want to point existing links to another source.

For instance, you might have a prior year workbook, and need to point to a new workbook when a new year starts. Selecting Change source will launch a file explorer dialog, where you can browse to the new source workbook. If the workbook has more than one worksheet, you will be prompted to specify which one to link to - just click the sheet you want and click OK. Note: It is possible to point a workbook back to itself by selecting it from the Change source dialog. This will sever any formula links to the originally linked source workbook.

Important: When you break a link to a source, all formulas that use the source are converted to their current value.

CC25 would be converted to the sum of the values in the source workbook. Because this action cannot be undone, you may want to save a version of the file first.

If the link used a defined name, the name is not automatically removed, so you may also want to delete the name. If you use an external data range, a parameter of a query may also use data from another workbook. You may want to check for and remove any of these types of links.

In the Name column, click the name that you want to delete, and then click Delete. This simply displays a notification in the Edit Links pane whether a linked workbook is still a valid source. It should display OK , but if it doesn't then you'll need to check on the source workbook. In many cases, a source workbook may have been moved or deleted, cutting the link. If the workbook still exists, you can use the Change Source option to relink the workbook.

Can I replace a single formula with its calculated value? When you replace a formula with its value, Excel permanently removes the formula. If you accidentally replace a formula with a value and you want to restore the formula, click Undo immediately after you enter or paste the value.

Click Don't Update. Excel cannot update from a source that is not connected. For example, the source may be on a network, and you may not be connected to that network. I don't want my current data replaced with new data. If the data does not need to be the most current, you can save time by not updating all of the links.