The Extensions Bulletin | July 2021
What's New?
Excel Add-in 4.3 available in phase 1: the latest version enables you to be more productive by rolling out the add-in more quickly to your users and working with multiple workbooks. We delivered 3 ideas:
Excel Add-in: Clone Workbook button - similar to this idea
Open duplicate workbooks
Back-up copy on Onedrive
Google Sheets Add-on: t his version allows any user with access to refresh the connection and data on a sheet. This new capability extends the ability for more users accessing a sheet to keep the connection and data up-to-date with the latest information.
Your Ideas
See an idea you like? Vote for it to increase its popularity.
New ideas
add options like Include Empty rows
Display Properties list
Google Sheet Addin: Remove leading spaces from Lists items
"While/Wend" or "Do Loop" Functionality in Anaplan
Ideas on roadmap
Security/restriction for the add-in - similar to this idea
PowerPoint Add-in integration with NewUX
PowerPoint Add-in chart types
Google Sheets Add-on: Send formula-driven figures back to Anaplan
Multiple connections per sheet (also in this idea)
Remove a connection from a sheet (also in this idea)
Excel Add-in for Mac - similar to this idea
Word Add-in
Add-ins for Office Online
Synchronize filters across tables - similar to this idea and this idea
Ideas delivered
Excel Add-in: Clone Workbook button - similar to this idea
Conversion to V4 - a copy of older version is not made on Onedrive
Unable to open several workbooks with the same connection
Google Sheets Add-on: remove connection owner limitation
No browser prerequisite
Recognition
Thank you to all Community members who submit ideas, this greatly helps to shape the roadmap!
Did You Know?
The new version of the Google Sheets Add-on is available automatically, no need to install or download it. Visit Anapedia for more information.
End-User Tips and Tricks
If an Excel file with an Anaplan Add-in connection is stored in Google Drive, it can be downloaded without issue. However, if that file is opened and edited in Google Sheets, when it is next downloaded, the Excel file will no longer recognise the Anaplan connections in the Add-in. Workaround: Google Drive will allow you to download older versions of the file. If you download a version from before the edit was made, the Anaplan connections will still work. More details about this known issue
Model Builder Corner
Excel Add-in 4.3 can now be installed with SCCM for all users, let your IT team know!
What's this bulletin? It's a regular update about the extensions, directly coming from the development team.
How does it differ from the monthly release post?
Contrary to the release information which covers all the Anaplan products, we focus on the extensions.
Why should I care? How does it impact me?
If you are one of our 1,000+ users of the products, then you might want to read our bulletins as well to be on top of everything that's going on. If you are a Master Anaplanner or on the path to become one, you should definitely be interested in learning this information too.
Do you like this bulletin? Would you like to suggest ideas?
Give some kudos on this Community post and help share this article on LinkedIn. If you have suggestions or feedback, please write them in the comments.
... View more