Connected workbooks not updating
We will look at the advantages of using cloud storage for your excel files.
For more information on how to import Excel files into Power BI, see Get data from Excel workbook files.
Maybe it wouldn't be able to build it relative without then being cofoldered.
Beware, if you then edit the excel file, excel may well change file references back to relative ones.
Note: modifying the hyperlink base is supposed to force excel to use absolute paths. I think this behavior is typical of Microsoft arrogance.
So, you can rewrite the vlookup as this =VLOOKUP($B; DDE("soffice";"/Users/tris/Documents/Cust_database.ods";"sheet1.
You can import Excel workbooks that are stored on your local machine, or in cloud storage such as One Drive for Business or Share Point Online.