If your model has elements that are linked to spreadsheets (e.g., Spreadsheet, Time Series, or Lookup Table elements), you may want the Dashboard 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.
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).
Learn more about: