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

Filter dropdown for form action
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on this…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…