Create a link between two Excel files

[mamelas]

Hi there,

I am trying to create a link between two excel files on an FTP Site but I can not find a working result.

What I have:
A folder x:\general costs
Inside this folder there is a file called costs1.xls which has 3 sheets
(Sheet 1, Sheet 2, Sheet 3)
Sheet 1 has for example 4 cells (A1, A2, A3, and A4)
Cell A1: drags values from sheet 2
Cell A2: drags values from sheet 3
Cell A3: drags values from a cell of another excel file that lives at x:\accounting\total.xls
Cell A4: drags values from a cell of another excel file that at
x:\year2011\year11.xls

What I would like to do:Inside General Costs folder I have created a sub-folder x:\general costs\ftp
This sub-folder is the root directory of my FTP Site.
In this folder I should create a link called cost2.xls that points to the Sheet 1 of cost1.xls
Please note that the FTP user should have access only to this folder and file
(he is restricted from accessing any other folder including the above ones).

My Problem:
Using “paste link” or the “Move or Copy” solution when I am accessing the ftp site a pop up window asks me to edit the excel links with message “source not found for total.xls and year11.xls”

Temporally I am saving the Sheet 1 of cost1.xls as a PDF.

Any ideas to make it work using excel?

Thanks for your time .