Multiple Excel files linked but portable.

[GeisonGDC]

Hello,

Is there a way to, for example, link multiple excel files, and then i can compress the documents in a rar file to share it, and the other person can extract the files and the links between files still works?

For example i have a "frontpage" document with links that open the other files, but when i share the documents, the links do not work anymore.

Thanks for your assistance.

 

[PeteWright]

Relative Paths should work.

For example assume the following file structure:

D:\Documents\Excel\TEST\frontpage.xlsx
D:\Documents\Excel\TEST\book1.xlsx
D:\Documents\Excel\TEST\book2.xlsx
D:\Documents\Excel\TEST\folder1\book3.xlsx
D:\Documents\Excel\TEST\folder2\book4.xlsx

Then format the hyperlinks like this:

frontpage.xlsx
book1.xlsx
book2.xlsx
folder1\book3.xlsx
folder2\book4.xlsx

Put all files in the same folder and pack it (RAR, ZIP, ...)

The links should work.