Excel Add-in Multiple View

Is it possible to publish multiple modules to one workbook in excel using excel add-in? I have a client that needs a dashboard (containing views from multiple modules) to be exported to excel that needs a specific formatting for shareholder's reporting. As far as I can see there's only one connection to a module per tab. Is there a work around for this?

Accepted answers

All comments

ArunManickam

@himanshu.badhai

You can configure one module for each tab(worksheet).

So you can configure multiple modules in one workbook.

Thanks

Arun

Misbah

@himanshu.badhai

One Module a tab is the only option that you have. You can not have data coming from multiple modules into one tab/sheet of the workbook. You can get all the modules in their respective sheets of the workbook and then consolidate it if needed. Or Else if consolidate everything in one module and then extract the module via addin.

himanshu.badhai

got it. Looks like that's the way to go. I was just trying to avoid 10 different connections/tabs. Wish we could do multiple connections on same excel sheet.

SteelFledgling

@Misbah wrote:
@himanshu.badhai/UPSer

One Module a tab is the only option that you have. You can not have data coming from multiple modules into one tab/sheet of the workbook. You can get all the modules in their respective sheets of the workbook and then consolidate it if needed. Or Else if consolidate everything in one module and then extract the module via addin.

Thank you for sharing superb information. Your website is very cool.

I’m impressed by the details that you have on this website.

MagaliP

You can vote for and track this idea (it's on the roadmap!): Multiple connections per worksheet in Excel

wayneooo

I did check it out it was really nice information,

I looking forward to know more while staying in community

upsers

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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