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?