Hyperlinks
1 TopicHyperlink 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) What does Word have to do with anything ? I chose an excel file, i dont even have any Word document on my whole drive lol 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.3.1KViews0likes0Comments