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.