Workbook Paths on LAN Help Needed

  • Thread starter Thread starter jeff.potts
  • Start date Start date
J

jeff.potts

How do I refrence a cell on a sheet that resides on the lan? I have
tried the following but get an error.

\\v1sacpdofc2\cpdprojects\CIS Financials\Costs Projections - bottom
up\Nov 04 actuals to end of program - reduced scope\Gantt Planner
Novemeber 2004 Incl New R3.xls.Tasks_Sheet!C12
Anyone have a suggestion or correction to my path naming.
 
Open that workbook using File|open and the UNC naming convention.

Swap back to the worksheet that should contain the formula.

type = (equal sign)
and click on the cell (C12) in the sheet you want to retrieve.
Hit enter.

Excel will build the formula for you.

When you close that workbook with the long path, excel will adjust the syntax
accordingly.
 
I can't go that way for the reference because it limits itself to the c:\etc
mapping that either forces the user to locate the file or have it already
open.

I still need to work with the server name concept and not the drive letter
mapping convention, using the example below;
\\v1sacpdofc2\cpdprojects\CIS Financials\Costs Projections - bottom
up\Nov 04 actuals to end of program - reduced scope\Gantt Planner
Novemeber 2004 Incl New R3.xls.Tasks_Sheet!C12

Anyone have a suggestion or correction to my path naming.
 
If you opened the file using the mapped drive, close it.

then File|open.
in the File Name box (at the bottom of the dialog), type:
\\vlsacpdofc2

and start following the folders down to your workbook.

(You could actually type the long name into that box--but I'd rather point and
click with my typing skills.)

Once you open it this way, try building the formula via pointing and clicking.

What does that formula look like.
 
You could get to that UNC folder via:
Start|Run and typing the \\vlsacdofc2
and traversing the folders.

Then if you double click on the workbook, I think it'll be using the UNC name.

===
Even going through "My Network Places" (Is that the correct name) in windows
explorer or on the desktop should work.
 
Back
Top