Submitting Data without Refreshing

This option allows users to submit all data from the worksheet.

Submit Without Refresh includes all data cells that you have explicitly modified (made dirty) and those that were not modified. All data cells are marked dirty and submitted.

Note:

To help you identify modified cells, set a cell style for dirty cells.

To submit data without first refreshing:

1. Connect to the data source and open an ad hoc grid.
2. Modify the data as needed.
3. From the provider ad hoc ribbon or Essbase ribbon, select Submit Data, then Submit Without Refresh.

   Data for all cells on the sheet is submitted, whether or not the cells are dirty.