Specifying a Linked Spreadsheet File Using a Button

If your model has elements that are linked to spreadsheets (e.g., Spreadsheet, Time Series, or Lookup Table elements), you may want the Dashboard A special GoldSim element that allows you to build custom interfaces or "control panels" for your models. user to be able to directly change the spreadsheet file to which the element is linked. This can be done by using a Button control A special control that can be added to a Dashboard that provides a mechanism for linking a wide range of actions to a button..

Within the Button control, you must select Select Spreadsheet File for Element for the command:

You then select the element whose spreadsheet linkage you wish to change. Note that when you click on <Click to select>, the dialog to select an element will only display Spreadsheet, Time Series and Lookup Table elements that are currently linked to spreadsheets.

Within a Dashboard, when the Button is pressed, a standard Windows dialog for selecting a new spreadsheet is displayed.

Note: This command does not provide any mechanism for you to define how the spreadsheet is linked to the element (e.g., the location in the spreadsheet). This information must already be specified inside the element. The Button simply provides a way to select a different spreadsheet file (that, of course, will need to be formatted in a manner consistent with how it is being used by the element).