Show linked files information.

[ncc]

I am using Excel 2000.
I am working with a file that have links to 5 other files.
I want to put in a cell, information about the linked files, like the name of the file, and the location in the disk of each file.
Also I need that this information changes when I change the linked files by doing: Edit...- Links...- Change Source...-
Can anybody help me.
Thanks
Ncc

[Richard Buttrey]

I am using Excel 2000.
I am working with a file that have links to 5 other files.
I want to put in a cell, information about the linked files, like the name of the file, and the location in the disk of each file.
Also I need that this information changes when I change the linked files by doing: Edit...- Links...- Change Source...-
Can anybody help me.
Thanks
Ncc

Easiest way if you don't want to enter the syntax manually, is to have the five files open, then build your formula in the main file by selecting the appropriate cells in the five files when appropriate during the formula building.

HTH