Hi,
I've a dynamic report within Excel where I want to use Excel's name manager to use more speaking names. So TM1RptTitle("Server:Dim";$L$36) should be come TM1RptTitle(MyDim;MyDimElem) where MyDim and MyDimElem are created using Excel's name manager instead of explicitly referring to a cell location.
If I just have one sheet within the workbook and create the names on the same sheet where the dynamic report lives everything works as expected. But: as soon as I create a separate sheet for holding the named cells (the names are created on workbook-level) the dynamic report won't resolve anymore in the web (but it does within Excel). On the other hand, referring to the cell on another sheet just works but it breaks in the web as soon as it is a named reference.
Is there any solution to this?
Paid Advertisement:
