In the past when I used export to excel the full path was shown as "../../../../../../../../Departments/EIDepartment/Shared Documents/Area Class Reference/FIGURE 2.pdf", which I could use as a hyperlink. Now all I get is "Departments/EIDepartment/Shared Documents/Area Class Reference" why the change? I will try and clarify, as recent as last month Dec 2019, when using "export to excel" the Path column in the exported excel file showed the url as ../../ etc and included the file, in this case FIGURE 2.pdf. I could then hyperlink to that and open the file. Now when using export to excel the Path doesn't include the ../ leaders and doesn't include the file name at the end. We are using Sharepoint with our Office 365 software which I am assuming is all the latest version. In my research I can't find any way to find what "version" of Sharepoint one is using.
Here is a similar issue post for your reference: