Exporting into multiple files/tabs

Hi,

I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible?

Thanks

Accepted answers

MagaliP

You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)

All comments

MagaliP

You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)

ChrisAHeathcote

@CommunityMember113484

Sadly I do not think this is possible via the UX or modelling environment.

However, I would explore using the add ins for Excel where you can create a dynamic link into your model and have the Excel update directly within Excel.

ashish.banka

@CommunityMember113484 While exporting, Pivot the product dimension into Pages. Now you can use Export>Grid Layout option and select "All Pages" radio button to export all the products data in single workbook with each product in separate tabs.

Screen Shot 2020-10-20 at 8.44.52 PM.png

Hope this helps

CommunityMember113484

Hi, Thanks for this - I've just downloaded the addin and I can only see it by a single product (as in the model builder view), but how do I get a new product per tab? Thanks

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385