Hi
I have a SMB share on a QNAP box which contains a folder tree. In these various folders are calc documents which need to access other files within the same set of folders.
I’m looking for a way to reference these other files from within the spreadsheet - no matter which machine / platform the user is running on. The trouble is: when I open the spreadsheet from some machine the file references in the doc are all based on the user’s local environment, not the NAS box.
This must be a very common scenario but I’m stumped . . 
Any helpers ??