Use the Excel Add-in if you prefer to perform a data analysis of your Anaplan data in Excel.
When an Excel worksheet is connected to an Anaplan module, the data displays in Excel.
When your Anaplan data is in Excel you can:
- View and edit data
- Pivot and filter
- Rename columns and rows.
List-formatted line items show as dropdown lists in editable cells. You can have a maximum of 32,767 items per list.
When a list contains more than 32,767 items, dropdown lists are not available.
Note: Sometimes you might get a popup message from Excel, which states Excel is waiting for another application to complete an object linking and embedding (OLE) action. This is a common Excel message. To remove the message, select Close