referencing cell range in different excel files

[from_laura]

I have files that individuals are updating individual schedule data that
I want to bring it together in a master sheet. I tried using reference
for just one cell and keep getting the REF! error. I would like to
reference the server name instead of the drive letter it is mapped to
if possible

Thanks for your help!

Here is the syntax I am using - just trying to see cell C!0:

=('\us1n50\PMffice\XP_upgrade_schecules\Pub_Sevices\[pub_schedule.xls]Sheet1'!C10)

us1n50 maps to my U: drive.



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------

 

[Dave Peterson]

I'm not on a network, but could it be as simple as starting with 2 backslashes?

\\usln50\....

And if you follow jr's suggestion, try opening the workbook using the UNC name.
(I'm not sure if excel will convert this to it's mapped drive, though.)

But if you're careful, it's just typing <vbg>.

I have files that individuals are updating individual schedule data that
I want to bring it together in a master sheet. I tried using reference
for just one cell and keep getting the REF! error. I would like to
reference the server name instead of the drive letter it is mapped to
if possible

Thanks for your help!

Here is the syntax I am using - just trying to see cell C!0:

=('\us1n50\PMffice\XP_upgrade_schecules\Pub_Sevices\[pub_schedule.xls]Sheet1'!C10)

us1n50 maps to my U: drive.

------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
at http://www.ExcelTip.com/
------------------------------------------------