I had to open an excel spreadshett. One sheet refers to another sheet, so it does not work with the tools I normally use.
It does work in office365.
This is the reference in the cells
='C:\Users\Person Name\Desktop\[this-actual-file.xslx]MIND'!B114
god I'm happy I don't have to deal with this shit more often.