Link between linked workbooks

3 posts / 0 new
Last post
Iman Lazuardi A+ 5
Link between linked workbooks

Hi,

Currently I'm building multiple linked workbooks for a company with many outlets, and I have no problem on linking consolidation workbook and outlet workbooks using export/import modules. But is it possible to make link between those outlet workbooks?

Thank you,

Ardi

Iman Lazuardi A+ 5

I just figured out that we can also make export/import modules between those outlet workbooks. awesome!

Michael Hutchens A+ 189

Hi Ardi,

Modano supports creating multiple-linked workbook projects, in which you can link as many workbooks together using import and export modules as Excel will allow you to open. It is very powerful stuff, and something a lot of Modano users leverage when building large, scalable multi-business unit models.

There's detailed documentation in the User Guide explaining it all here: www.modano.com/resources/user_guide/automation/multiple_workbooks

This graphic does a good job of visualizing how it all works:

Enjoy!