Migrate the Excel Add-in from version 2.6 to the latest version 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 works in Microsoft windows on your PC only.
Before you migrate to the latest version, ensure you only have Excel Add-in version 2.6 installed on your PC.
When you migrate to the latest version of the Excel Add-in, you have the option of condensing the data from multiple worksheets into context selectors.
To prepare:
To migrate a single worksheet:
Update any cells that reference the 2.6 worksheet to reference the worksheet of the latest version of the Excel Add-in.
Tip: Use Excel's Find and Replace tool to help you find and replace the references.
You've now migrated to the latest version of the Excel Add-in.
To migrate multiple worksheets:
A key enhancement in the latest version 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:
Solved!去解决方案。
Please note that all above is valid for 3.2/3.3/3.4 versions.
Please find below a video showing how to migrate your workbook.
There is now an app in the app hub to help you estimate the time it would take you to migrate your workbooks. Download it here >>>https://community.anaplan.com/t5/Other/Migrate-Excel-Add-in-version-2-6-to-version-3-2/ba-p/55008