Accessing Linked Files

An LRO is a cell note, an external file, or a URL that you link to a cell in an Essbase database. Users with access permission can access the LROs to view or edit their content.

  To access a linked file:

  1. Open the worksheet and connect to an instance of Essbase Server.

  2. To retrieve data into the worksheet, select Essbase, and then Retrieve.

  3. Select the data cell to which the object is linked.

    In Spreadsheet Add-in, you can identify a linked object by setting a style for it.

  4. Select Essbase, and then Linked Objects.

    The objects linked to the selected cell appear in the Linked Objects Browser dialog box.

  5. Select the file you want to access.

    The next step depends on the action you want to perform with the file:

    • To view or launch a linked file:

    1. Click View/Launch.

      Essbase retrieves the file and sends it to your computer. If the file is an executable file, your computer launches it. If the file is a document, such as a Microsoft Word or Excel file, your computer launches the application and loads the file. (If the document is not associated with an application, you must create the association. See the Microsoft Windows documentation.)

    2. Close the application when done viewing the file.

    • To edit the contents of a linked file:

    1. To launch the file editing application, click View/Launch.

    2. Edit the file and save it to your local disk drive, making note of the file name.

    3. Close the editing application and return to the Linked Objects Browser.

    4. Click Edit.

    5. In Re-Attach Linked Object, enter the name of the edited file, and then click OK.

Related Topics

Accessing Cell Notes

Accessing URLs

Creating Cell Notes

Deleting LROs

Linking Files to Data Cells

Linking URLs to Data Cells