How to add a link to different sheet when creating the BI template layout in EXCEL
Hello,
I am creating a BI report using excel template. It has multiple detail sheet and a summary sheet.
User wants a 'Link' in summary page which will navigate to the corresponding detail sheet.
I just inserted a 'Link' from the excel menu and defined the destination as the target cell in the sheet.
This is working fine within the template. But when I run the report the link disappears and it just appears as a text.
Can you please guide how can this be achieved?
Thanks,
Sujan