Running Functions

You can run most Smart View functions automatically using Refresh commands.

For HsGetValue, use the Submit Data command.

To run functions and retrieve values:

  1. Connect to a data source.
  2. Open the sheet that contains the functions you want to run.
  3. Do one of the following:
    • For HsSetValue, click Submit Data.
    • To run functions and update all the sheets in the workbook, click Refresh.

    Note:

    When opening a workbook containing functions created on Oracle Smart View for Office, you will need to run the Fix Links command. See Fixing Links in Functions.