When a dataset is added to a spreadsheet, this dataset is then executed when the spreadsheet is opened. This makes the data available to the spreadsheet for the purposes of lookup lists or for editing.
When you open a spreadsheet definition, you will see a list of datasets which are linked to the spreadsheet.
A dataset can be configured so that it’s in read mode only or can be available for data update (in which case the dataset requires a primary key defined in the field list).
After adding a dataset you can configure a Spreadsheet to accept data from a linked Dataset