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: