I have 2 sheets in a excel file, one of the sheet name is 'Test' and another one is 'Final Data'.
Creating hyperlink from sheet 'Test' to sheet 'Final Data'. My code is as below
But it is not working, showing 'Reference Invalid' error.![]()
Please Login or Register to view this content.
Suppose my second sheet name is 'FinalData' (without space) it is working fine. I can't send this file to client with a sheet name 'FinalData'.
Anyway to create a hyperlink to a sheet which contains blanks in its name?
Bookmarks