I have an odd problem. Links from one spreadsheet to another spreadsheet include absolute pathways

[Robert_Nikjoo]

This causes me problems as I just now can use this spreadsheet only on my computer.

I need the link to be relative so I can send the files to a client.

It shows as

='C:\directory1\directory2\[workbook1]!a1'

when I need it to be ='[workbook1]!a1'

Can anyone help?

[#2 · Accepted solution]

@Robert_Nikjoo 

Please check this thread How to reference a cell in another workbook without storing absolute path to source file - Microsoft... if helps.

[#3]

@Sergei Baklan

Thank you very much. most useful article.