Lesson: Linking a Cell Note to a Data Cell

In Spreadsheet Add-in, you can link individual cell notes that contain information on data cells. Cell notes can consist of no more than 599 characters. To link information to a data cell that is longer than 599 characters, you must create and save an external file and link the file to the data cell.

  To link a cell note to a data cell:

  1. In the Asymm.xls file, select cell C5.

    Note:

    You can link objects only to data cells, not to cells containing member names.

  2. Select Essbase, and then Linked Objects.

    The Linked Objects Browser dialog box is displayed.

  3. In Linked Objects Browser, click Attach.

    The Attach Linked Object dialog box is displayed.

  4. Under Attachment Type, select Cell Note.

  5. In Cell Note, enter this note: 

    This number needs to be updated by the Easters Sales Manager.

  6. Click OK.

    Essbase copies the note to the server and establishes a link to the current data cell.

  7. Click Close.

  8. Select Essbase, and then Retrieve.

    Now Essbase displays two data cells (C5 and D5) in purple, italic font to represent a cell containing a linked reporting object

    Result of Creating a Linked Cell Note

Leave the Asymm.xls file open for the next tutorial task.

User Reference

Creating Cell Notes