Hi,

I am making a an Excel spreadsheet which has a few cells which need to
query some information from another Excel file located on an FTP
server.

In order to do this I set the relevant cell in my spreadsheet to
"=[name of the spreadsheet on the ftp site]cell coordinates". I do
this by opening the spreadsheet on the FTP server in excel (when I
open it through explorer, I get an embedded spreadsheet inside IE and
I can't seem to copy and paste the relevant information) and copying
and pasting the relevant cell.

The problem I encountered is that the relevant cell in my spreadsheet
fails to update (404 - file doesn't exist), the interesting thing it
does update if I open a copy of the spreadsheet on the FTP server with
the source information.

I am using Excel 2003 SP2.

In general, I wondering if anyone could suggest a way to retrieve
information from a cells in spreadsheet located on an ftp server?
Optimally, my spreadsheet should be able to update as long as it has
access to the internet.

On Jun 12, 3:11 pm, wintermute wrote:
Hi,

I am making a an Excel spreadsheet which has a few cells which need to
query some information from another Excel file located on an FTP
server.

In order to do this I set the relevant cell in my spreadsheet to
"=[name of the spreadsheet on the ftp site]cell coordinates". I do
this by opening the spreadsheet on the FTP server in excel (when I
open it through explorer, I get an embedded spreadsheet inside IE and
I can't seem to copy and paste the relevant information) and copying
and pasting the relevant cell.

The problem I encountered is that the relevant cell in my spreadsheet
fails to update (404 - file doesn't exist), the interesting thing it
does update if I open a copy of the spreadsheet on the FTP server with
the source information.

I am using Excel 2003 SP2.

In general, I wondering if anyone could suggest a way to retrieve
information from a cells in spreadsheet located on an ftp server?
Optimally, my spreadsheet should be able to update as long as it has
access to the internet.

Anyone?