The connection to Anaplan still works after you edit a card's data in Excel. When you refresh a card, it pulls the latest data from Anaplan and overwrites any data you edited in the Excel spreadsheet.
User authentication in Anaplan is inherited by the add-in. For example, users with a read-only license in Anaplan have read-only access in the add-in.
If a page builder configures a grid card as read-only for all users, the card becomes editable in the add-in for all users with a read-write license in Anaplan.
The add-in inherits the access restrictions set by model roles, selective access, and dynamic cell access.
Refresh your cards
You can reinsert refreshed cards into your document and display the latest Anaplan data.
To refresh your cards, on the Cards in Document tab, select one or more cards and select Refresh.
To update Anaplan with data changes, use Send and refresh.
Card connection issues
In the Cards in Document tab, the Connection status for each card displays to the right of their names. You lose your connection to a card when:
- The card template is deleted from Anaplan.
- You no longer have access permissions to a card's source data.
- The card is hosted in a different environment.
In this case, sign in to the correct environment to work with the card.
Once you have solved any connection issues, you can refresh your cards. You can refresh more than one card at a time and refresh a card you've inserted in to your document multiple times.