nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting into multiple files/tabs

CommunityMember113484

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

Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
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.…