Linking to a spreadsheet in the same folder without folder path
Hi guys,
I have the following issue:
I link a cell to another cell form another excel file. Later on I want to print it on a CD and give it to someone else. So I do not use any paths for the links. However, when I close it and re-open it, all the links are not like [FileName.xlsx]'!Tabel1, they look all look like this: C:/users/.../[FileName.xlsx]'!Tabel1
How can I fix this that the link will be adoptable and it works on the CD or any other device?
|