I have prepared a form in LiveCycle Designer 8.0. Now I am trying to figure a way of linking data in an Excel Spreadsheet (or some "converted" form of an Excel spreadsheet) to areas in the form. What I would like to be able to do is update the spreadsheet, click on a link to the form template within the spreadsheet, and have the form populated with a particular row of data from the spreadsheet.
Is there a way of linking a cell in an Excel spreadsheet to a "cell" in a LiveCycle form, so that it automatically updates upon opening the form, and if so, how is this done? I am obviously a novice at this.