Submitting Data Without Refreshing

Data source types: Essbase, Planning Ad Hoc, Financial Management Ad Hoc

  To submit data without first refreshing:

  1. Connect to the data source.

  2. Optional: To help you identify modified cells, set a cell style for dirty cells, as described in Cell Styles.

  3. Modify data as needed.

  4. From the provider ribbon, select Submit Data, then Submit Data Without Refresh.

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

Note:

If you are working with multiple grids on a worksheet, see Guidelines for the Submit Data Options.