In series 4 of the Excel Add-in, use Send and Refresh to write data changes made in the add-in back to an Anaplan module or saved view.

You can only use Send and Refresh with a read/write connection, including multi-sheet read/write connections.

When you send data, it adds an entry named Bulk data change (add-in) to the model history.

The maximum number of cells you can write to Anaplan with Send and Refresh at a time is 1 million.

Connections in the add-in can contain up to 5 million cells, but you can only write 1 million cells to Anaplan at a time.

To send and refresh data:

  1. Make data changes in your connected worksheet.
  2. Select outside of any cells you made changes to or press Enter to validate the data change.
  3. On the Anaplan ribbon, select Send and Refresh.
    The Finding Changes dialog displays along with the Send and Refresh pane, which displays on the right.
    Once the Finding Changes dialog completes, it displays the number of changes in the connection.
Send and Refresh displays when you create a read/write connection.
  1. Select Close.
  2. In the Send and Refresh pane, confirm the changes to be sent.
  3. You can use the Only Errors toggle to display only changes that cannot be written to Anaplan.
  4. If you send and refresh a multi-sheet connection, a dropdown list displays under Changes. Select each worksheet from this list to review the changes for them.
  5. Select Submit to write your data changes to Anaplan.
    The Send and Refresh dialog displays:
    • Success if the data changes were written to your Anaplan model.
    • Errors detected if data could not be written to your Anaplan model. In this case, troubleshoot any errors in the Send and Refresh pane.
Use the Send and Refresh pane to resolve errors and submit data changes.
  1. Select Close.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.