Migrate the Excel Add-in from version 2.6 to version 3.2 to benefit from: faster performance; the ability to connect to saved views; the use of context selectors; and the use of pivot and filter to orientate and condense your data to one worksheet.
Excel Add-in version 3.2 works in Microsoft windows on your PC only.
To migrate to version 3.2, ensure you only have Excel Add-in version 2.6 installed on your PC.
When you migrate to version 3.2, you have the option of condensing the data from multiple worksheets into context selectors.
To migrate a single worksheet:
Update any cells that reference the 2.6 worksheet to reference the 3.2 worksheet instead.
Tip: Use Excel's Find and Replace tool to help you find and replace the references.
You've now migrated to version 3.2.
To migrate multiple worksheets:
A key enhancement in version 3.2 is that it imports the page selectors from your Anaplan saved view. This means you can condense your data into one worksheet.
To migrate the data for different dimension values: