Forum Discussion
Hyperlink to a specific Excel sheet In Outlook
Hi,
I would like to send an email with Outlook containing a hyperlink to a specific Sheet of an Excel Workbook to gain time and avoid the infamous "oopsie, I edited the wrong sheet".
I am able to create an hyperlink using the Insert > Link > chose a document but when i try to click on Bookmark to chose a sheet an error occurs (sorry my SS are in French)
If I do the same thing in Excel, I am able to see the list of the tabs avaible in my workbook, as bookmarks
If I attempt to edit my link "by hands" with the syntaxe My path/My file.xlsm#'My Sheet'!A1 (or to simply copy/paste the "address" Excel generate when I select the Sheet through the link creation insert menu) Outlook accepts my link, but when I select it, it's considered as an attached file (?)
So of course, it's unable to find the source as its pointing toward a "file:/// ..." and I end up, once again on an error.
The same link opened in Excel Excel opens the correct worksheet without any trouble.
As of now, I am only able to create a link toward a "general" workbook, but i am unable to point to a specific sheet within it.
Why is outlook unable to consider Worksheet as bookmarks when it is possible in Excel ?
An what can i do to tell my coworkers "here Edit That Sheet" and they are prompted the right sheet in the right workbook in the right place.
Thanks!
NB : My company uses Microsoft Office Standard 2019, 1808
Tartofraises.