Excluding full path to linked file on a networked drive

[Scott]

Hello,

I have two excel files -- A and B. Both files are saved on a network
drive in the same directory. In file A, I have links to cells in file
B.

Because the files are in the same directory, is it possible to not
have Excel show the entire path to file B in the formulas in file A
that link to file B? The network path is quite long and it makes it
difficult to read the formulas?

If file B is open, the formulas just show the name of the file,i.e.
. Is it possible to always have this shown?

THanks,

 

[Jim Cone]

How about using a cell reference that contains the file path?
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(List Files XL add-in: finds and lists files/folders with hyperlinks)





"Scott" <[email protected]>
wrote in message
news:[email protected]...

 

[Dave Peterson]

I don't think that this would be a good idea.

I'm guessing that =indirect() would be used somewhere to include that cell's
value (the path). And that fails if the "sending" file is closed.

There are workarounds using addins (Harlan Grove's =Pull() and Laurent Longre's
=indirect.ext(), but they are addins that each user would have to have installed.

 

[Dave Peterson]

I don't think so.

Hello,

I have two excel files -- A and B. Both files are saved on a network
drive in the same directory. In file A, I have links to cells in file
B.

Because the files are in the same directory, is it possible to not
have Excel show the entire path to file B in the formulas in file A
that link to file B? The network path is quite long and it makes it
difficult to read the formulas?

If file B is open, the formulas just show the name of the file,i.e.
. Is it possible to always have this shown?

THanks,

 

[Dave Peterson]

But an option may be to use a cell on a (hidden) sheet that retrieves the value
that you want.

Then use that cell in your formula.

I don't think so.

Hello,

I have two excel files -- A and B. Both files are saved on a network
drive in the same directory. In file A, I have links to cells in file
B.

Because the files are in the same directory, is it possible to not
have Excel show the entire path to file B in the formulas in file A
that link to file B? The network path is quite long and it makes it
difficult to read the formulas?

If file B is open, the formulas just show the name of the file,i.e.
. Is it possible to always have this shown?

THanks,