1. Extensions
  2. Excel Add-in Series 4
  3. Refresh
  4. Solve refresh errors

In series 4 of the Excel Add-in, learn how to troubleshoot when a Send and Refresh detects errors.

You only need to troubleshoot if you tried to use Send and Refresh and it did not complete. 

For most errors, select Refresh and see if the data in the model or your access permissions have changed.

Possible reasons that your Send and Refresh request did not complete include:

Error detectedHow to solve it
Your permissions changed in your connected Anaplan module or saved view since your last refresh.Ask a workspace administrator to check if your permissions changed. Without the correct permissions, you can no longer apply your changes.
The Send and Refresh does not complete as data in the Anaplan model changed before you submitted your changes.

Another user has made changes to the data in Anaplan since your last refresh.

Refresh to update the Excel Add-in with the latest data from Anaplan and continue your data analysis. 

The cell range(opens external page) of the connection is broken.

If you break a connection's cell range, it may not refresh properly.

In order to include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert columns and rows in a worksheet(opens external page) and you can rename columns and rows in a worksheet, but you must keep the cell range continuous.

The cells in Anaplan were Read/Write in the previous connection but have changed to Read-Only. You can no longer edit them.

If you have access, return to the Anaplan model and revert the cells to Read/Write.

Otherwise, refresh the Excel add-in and continue your data analysis with the latest Anaplan data.

Cells are read-only. 

Cells are read-only if they contain a formula, are affected by Breakback, or if you no longer have read-write access.

Refresh and continue your data analysis with the latest Anaplan data.

If the send and refresh connection has errors, a Send and Refresh pane displays on the right of the Excel worksheet. 

To troubleshoot:

  1. Check the cells you revised.
    These are listed in the Send and Refresh pane.
  2. Select the changes in the Send and Refresh page that you want to reapply or undo, then either:
    • Click Submit.
      The changes are sent and refreshed to your Anaplan module or saved view again.
      If you receive another error message, this could be due to the change being invalid. In this case, undo the change.
    • Click Undo changes.
      This is recommended if the Value type mismatch icon displays next to the listed data change.
      The selected changes are removed from your worksheet. 
The Changes pane displays your data changes and their status.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.