Updating Simulation Master Links

Simulation Master Tutorials > Updating Simulation Master Links

When a workbook containing Simulation Master worksheet functions is saved on one computer, and opened later on a another computer, the links need to be updated.  This tutorial assumes that Simulation Master is installed, otherwise links cannot be updated.

When a Simulation Master worksheet function is entered in a cell, a link is created between the workbook and the Simulation Master add-in on the current computer.  If the workbook is opened on a different computer, this link needs to be updated to the copy of Simulation Master on that computer.

The example below shows an RV function in a workbook created on another computer.  The path to Simulation Master on that computer is placed in front of the RV function.  The function will not compute until the link is updated.

Link Startup Prompt Setting

When you open a workbook containing a link that needs to be updated, you may or may not get warnings about the links.  Whether you get a message or not depends on the startup prompt message setting for the workbook.

For each Excel workbook, you can control link startup prompts by clicking the Data tab, and then Edit Links.

The Edit Links window will appear.

Click the Startup Prompt... button and the following window will appear.

Depending on the setting, you may or may not get a warning that links are not up to date.  We'll cover each of the scenarios based on the startup prompt setting.

Let users choose to display the alert or not

The first time the workbook is opened, you will get the following warning.

For now ignore this warning.  After the links have been updated, you can click Enable Content to prevent this warning the next time the workbook is opened.

If the Enable Content button was clicked, but the workbook was not saved, you will get the following message each time the workbook is opened.

Click the Don't Update button, to close this message.

Then click on the Simulation Master tab and then click the Update Links button.  This will update the link between the workbook and the Simulation Master add-in file on the current computer.

If the link was updated successfully, you will get this message.

You can now click the Enable Content button to close the security warning.  Save the workbook to preserve the updated link.

Don't display the alert and don't update automatic links

For this setting, you won't get any warning that links are not updated.  Go to the Simulation Master tab and click the Update Links button.

If the link was updated successfully, you will get this message.

Save the workbook to preserve the updated link.

Don't display the alert and update links

The first time the workbook is opened, you will get the following warning.

For now ignore this warning.  After the links have been updated, you can click Enable Content to prevent this warning the next time the workbook is opened.

If the Enable Content button was clicked, but the workbook was not saved, you will get the following message each time the workbook is opened.

Click the Continue button, to close this message.

Then click on the Simulation Master tab and then click the Update Links button.  This will update the link between the workbook and the Simulation Master add-in file on the current computer.

If the link was updated successfully, you will get this message.

You can now click the Enable Content button to close the security warning.  Save the workbook to preserve the updated link.

DON'T DO: Breaking the Link

One thing that should not be done is breaking the link.  This will erase all Simulation Master functions and replace each cell with its current value.  If the link is broken, you will have to do one of two things:

  1. Re-enter each Simulation Master function.
  2. If you have previously exported Simulation Master functions to a worksheet in this workbook, you can import them back into each cell using the Function Swap tool.  This is a good reason to export a back-up of all Simulation Master functions.

We will show how to break a link so that you don't accidentally do it.

Click the Data tab, then click the Edit Links button.

The Edit Links window will appear.

Click on the Simulation_Master.xlam and then click the Break Link button.  AGAIN, DON'T DO THIS.