Question about a Report Book

grillin7
New Contributor II

Hello, I have a Book in OneStream that generates the following:

grillin7_1-1675350579058.png

The book generates the following excel with data in each tab (without the index tab), I add the index tab manually with the Hyperlink code

grillin7_4-1675351260753.png

 

In the Index tab, I have manually created a code to put some hyperlinks from the Excel frame.

 

grillin7_3-1675351175242.png

 

I would like to know if it is possible when generating the Book from OneStream I can create a code so that the Hyperlinks are made at the same time that OneStream generates the Excel from the Book and not manually create a macro from Excel after generating the books.

 

Thank you a lot team

1 REPLY 1

JackLacava
Community Manager
Community Manager

What you're asking is basically a Table of Contents, which I don't think you can have at the moment.

I have a feeling someone asked for this enhancement in IdeaStream, so maybe have a look there and upvote it - or post it anew if there is nothing.