Creating hyperlinks to other worksheets in the same Excel workbook

[Matteop9]

Hi all

I looking to render an excel workbook that functions the same as the attached Excel file.

Using the render tools to dynamically created sheets and then in a master sheet be able to link to those subsequent sheets.

Attached is a workflow I am trying to build to get this done but am only getting errors where the reference sheet cannot be found.

Any help would be appreciated.

[ChrisTX]

See if this helps:

Creating Excel Hyperlinks to Sheets

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-Excel-Hyperlinks-to-Sheets/m-...

Chris

[IraWatt]

Hey @Matteop9,

Two changes I made to get it to work, I removed the quotes around the sheet name and added a # instead of a space:

Any questions or issues please ask :)
HTH!
Ira

[IraWatt]

They key to finding the right format was to copy and paste the link into word:

Excel seemed to lie a bit about how the link was structured 

[zheny0010]

That # sign is the key!!!

thanks a lot, I finally got it work

[IraWatt]

Great to hear it worked @zheny0010 !