I have created 4 workbooks for a client one of which refers to cells in the other 3 workbooks.

Those links appear as my directory structure (F:\ClientDirectory\[FileName... etc). Not only is his directory structure is totally different to mine, he is using Office 365 on an Apple.

Is there another way of linking these files so that the links will be picked up? Who mentioned clutching at straws?