Running Functions

When a worksheet that contains saved functions is opened on a different computer from the one on which it was created, the functions include the full path of the original computer. Oracle Smart View for Office automatically updates these function paths when you open the worksheet if all three of the following conditions are met. Otherwise, you must manually update functions using the Excel Links option.

  • The worksheet is unprotected.

  • The Excel option Ask to update automatic links is cleared.

  • When you open a workbook, if prompted to update link automatically, select Continue or Cancel. Do not select Edit Links.

To run functions and retrieve values:

  1. Open the worksheet that contains the functions you want to run.
  2. Do one of the following:

    • For HsSetValue, from the Smart View ribbon, select Submit Data.

    • For other functions, select one:

      • To run functions and update all worksheets in the workbook, from the Smart View ribbon, select Refresh all Worksheets.

      • To run functions and update only the active worksheet, select Refresh.