Steps to Submit Data

To submit data:

  1. Connect to the data source and display a plan or a form in the grid.

  2. Modify the data as needed.

  3. Ensure that your cursor is somewhere in the grid; then, from the Smart View ribbon, click the Submit Data button:


    Submit Data button in the Smart View ribbon

    A message is displayed showing you the progress of the submit operation:

    Progress message that displays when performing a submit

    When the submit operation is complete, the progress message closes automatically. You may not make any changes to the grid or form, or switch to a different worksheet, until the progress message is closed. For more information, see Guidelines for Submitting Data.

Note:

  • When you submit data, all dirty cells on the worksheet are submitted.

  • In the browser version of Excel 365, the Submit Data button is disabled during the submit operation, while the progress message is displayed. However, in Excel 365 for the Mac, the Submit Data button is not disabled, even though the progress message is displayed. To prevent Excel 365 on the Mac from hanging, do not click the Submit Data button until the progress message is closed.