Create Excel link under FTP Site
Posted on 2011-03-22
I am trying to create an Excel link under my FTP Site.
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 for example at x:\accounting\total.xls
Cell A4: drags values from a cell of another excel file that lives for example 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).
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”
I guess that maybe this problem occurs due to Network Permissions.
Temporally I am saving the Sheet 1 of cost1.xls as a PDF.
Any ideas to make it work using excel links?
Thanks for your time.