Create a link between two Excel files

mamelas

New Member
Joined
Mar 17, 2011
Messages
1
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 :biggrin:.
 

Forum statistics

Threads
1,085,495
Messages
5,384,007
Members
401,871
Latest member
allemandi

Some videos you may like

This Week's Hot Topics

Top