title: Office / Excel 365 - use relative hyperlinks instead of OneDrive
body: <p>I asked this question on Microsoft TechNet 2 weeks ago but have not received any answer. (<a href="https://techcommunity.microsoft.com/t5/excel/office-excel-365-use-relative-hyperlinks-instead-of-onedrive/m-p/3068778" rel="nofollow noreferrer">https://techcommunity.microsoft.com/t5/excel/office-excel-365-use-relative-hyperlinks-instead-of-onedrive/m-p/3068778</a>)</p>
  <p>I've recently been &quot;upgraded&quot; to M365 on my work computer, and it's been .... interesting.... There's a lot of changes, a lot of things have moved around. I'm getting used to it, and finding out how to solve things that are new/bugging me. However, I'm yet to find a solution to relative hyperlinks.</p>
  <p>I have one Excel Workbook which is my index/summary of a bunch of other spreadsheets/docs. (An example, I have plenty of books with these links!) The index doc shows me where the other information is stored and its status. I want to hyperlink to each of the child spreadsheets/documents, which are in sub-folders of the folder my index workbook is in. E.g. there is one spreadsheet holding the data for each date. Previously, this would just link to &quot;\2022-01-21\dailydata.xlsx&quot;. If it was in a parallel folder, it would link to &quot;..\otherProject\docs\mydoc.docx&quot;.</p>
  <p>Now I'm on M365 and OneDrive, <strong>EVERYTHING</strong> is linked to the online address for the OneDrive doc, e.g. a link to a file in the same folder as the spreadsheet I'm working on, instead of being &quot;TheOtherSheet.xlsx&quot;, is instead linked to &quot;https://my-company.sharepoint.com/personal/my_name_and_company/Documents/Documents/Customers/This%20Customer/This%20Project/Issue%20Tracker/Issue%2001/Data/TheOtherSheet.xlsx&quot;...!!!</p>
  <p>Opening old files with relative hyperlinks converts the links to the online target.</p>
  <p>Yes, the links still work and open the local file when I'm offline (critical!). However, it doesn't make any sense, and it makes the links harder to quickly check / understand visually. I haven't tested what would happen if I were to move a project folder containing relative references to sub-folders; I'm assuming that OneDrive will fix the links...? Sort of afraid to try.</p>
  <p>Is there any way to get the old style relative hyperlinks back?</p>
  <p>Update: I've just discovered that when I click on one of these hyperlinks to a file on my PC, it downloads it from the cloud, creating a new file in my downloads folder instead of opening the bloody file on my PC!!!! It also takes me to the SharePoint version of linked folders instead of going to the folder!</p>