Error Messages/UnsavedLinkSources

"Unsaved OLE link sources warning" is a message that might pop up when you try to close a model or quit Analytica. Here is the main text of the message:

"Unsaved OLE link sources exist in your model. You will not be able to reestablish connections when you reopen the model without taking action. Yes = close anyway. No = keep open and save link sources or break links."

When you quit or close, Analytica goes through the list of OLE links in the model, and uses this message to alert you if you have links that were established with data sources that were not saved when the links were established, or not saved before you last closed the model. An example would be a new Excel spreadsheet that you copy data from and use paste special to link to an Analytica table. If you try to close the model before saving the spreadsheet, there is no file backing the spreadsheet and if you go ahead and close, the next time you reopen, Analytica will not have an Excel file name to search the system for in order to reestablish the connection.

You can answer Yes and close Analytica anyway. Or you can answer No and keep Analytica open and use the OLE Links option under Edit to see your list of links in order to identify which links the message is referring to. If your Excel spreadsheet is still open, if you save it Analytica will automatically update the link sources. Otherwise, you can break the links before closing. Or you can simply close the model without taking any action.

If you close the model first and save Excel afterwards, this will not update the link in the model. And if you keep the unsaved Excel spreadsheet open and reopen the model, this will not reestablish the connection either. In any case, you can always break the link at any time, as it isn't doing anything for you. The data copied into Analytica, of course, will remain.

Comments


You are not allowed to post comments.