1. Extensions
  2. Excel Add-in 3.4
  3. Work with Anaplan model data in Excel
  4. Send and Refresh a read-write connection
  5. Troubleshooting send and refresh

Occasionally a send and refresh request that you made in Excel to apply the data changes to your Anaplan model may not go through.

There are reasons for this that we consider here.  

You only need to troubleshoot if your send and refresh connection could not complete.
A dialog will display with the status of the send and refresh.

Here are some possible reasons that your send and refresh request did not go through:

  •  Your permissions have changed in your connected Anaplan module or saved view since your last refresh. Ask a workspace administrator to check if your permissions have changed. If you no longer have access to the module or saved view, then you can no longer apply your changes.
  • Another user has made changes to the data in Anaplan since your last refresh. 
  • The cell(s) in Anaplan were read-write in the previous connection but have changed since to read-only.
    Cells may be read-only if they contain a formula, are affected by Breakback, or if you no longer have read-write access to the cell.

If the send and refresh connection has errors, a Changes panel displays on the right of the Excel worksheet. 

To troubleshoot:

  1. Check the cells you made changes to.
    These are listed in the Changes panel for you to review.
    You can either re-apply or discard these changes.
    If the change is invalid, a Value type mismatch icon displays next to the listed data change. Discard this change (see Step 3).
    Otherwise, identify why the error occurred and correct this error before you re-apply your changes.
    If the error is due to one of the reasons listed above, you may need to make a change in the Anaplan model itself.
  2. Select the changes in the Changes panel that you want to re-apply or discard.
  3. Either:
    Click Re-apply your changes and then click Send and refresh.
    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, discard the change (see below).
    Or:
    Click Discard 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. 
  4. If you discard your changes, you can make new data changes and send and refresh your connection again.