I have an Excel file that I am keeping on a server that I would like to have my users open. The problem with this file is that it is 35 megs and one of the users is on a VPN somewhere 2000 miles away. To make matters worse, the data in the file is changed everyday so users need to reload the file everyday. I'm sure you see the inherent problem with d/ling a 35 meg file every day. The solution I see to get around this is if I can extract specific cells worth of data as that is all the user needs. So, I would like to open the Excel file on the server for reading without actually having to download the entire file. Is this possible? If not, are there any other solutions?

Adam,

Excel worksheets can reference cells in other Excel workbooks. One
suggestion would be to create formulas in the Master Workbook (35 GB file)
that reference an external file (small filesize). The user could load the
large master workbook on their computer once and then download the small
Excel data file with the new information each time they want to use the
spreadsheet. You could even automate the download process when the master
file is opened.

An example of a cell formula to an external workbook is:
='C:\My Documents\Excel\Junk1\[NewData1.xls]Sheet1'!$A$1

Troy

"Adam" wrote in message
...
I have an Excel file that I am keeping on a server that I would like to
have my users open. The problem with this file is that it is 35 megs and one
of the users is on a VPN somewhere 2000 miles away. To make matters worse,
the data in the file is changed everyday so users need to reload the file
everyday. I'm sure you see the inherent problem with d/ling a 35 meg file
every day. The solution I see to get around this is if I can extract
specific cells worth of data as that is all the user needs. So, I would like
to open the Excel file on the server for reading without actually having to
download the entire file. Is this possible? If not, are there any other
solutions?

If the data is strictly formatted and you know the data structures you could
use ADO and SQL to extract what you want.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Adam" wrote in message
...
I have an Excel file that I am keeping on a server that I would like to
have my users open. The problem with this file is that it is 35 megs and one
of the users is on a VPN somewhere 2000 miles away. To make matters worse,
the data in the file is changed everyday so users need to reload the file
everyday. I'm sure you see the inherent problem with d/ling a 35 meg file
every day. The solution I see to get around this is if I can extract
specific cells worth of data as that is all the user needs. So, I would like
to open the Excel file on the server for reading without actually having to
download the entire file. Is this possible? If not, are there any other
solutions?

Hi Adam,
Have you tried VNC? www.realvnc.com
(I just tried the url and got nothing. Maybe its busy)

There is a windows built-in way also. See startprogramsaccessoriesremote
desktop connection. (winXP)


--
John
johnf 202 at hotmail dot com


"Adam" wrote in message
...
| I have an Excel file that I am keeping on a server that I would like to
have my users open. The problem with this file is that it is 35 megs and one
of the users is on a VPN somewhere 2000 miles away. To make matters worse,
the data in the file is changed everyday so users need to reload the file
everyday. I'm sure you see the inherent problem with d/ling a 35 meg file
every day. The solution I see to get around this is if I can extract
specific cells worth of data as that is all the user needs. So, I would like
to open the Excel file on the server for reading without actually having to
download the entire file. Is this possible? If not, are there any other
solutions?