Sunday, August 26, 2007

Fixing Excel Links to Other Data Sources

Ever get this message when opening a model?

This workbook contains links to other data sources.

If you update the links, Excel will attempt to retrieve the latest data.
If you don't update the links, Excel will use the previous information.

Most times when you are creating models you don't intentionally create links between excel files, but somehow one got created. You can get rid of this message by going to Edit->Links (Alt+E,K). You can see the links and break them if you'd like, or fix them in some other way.

No comments:

Sunday, August 26, 2007