"Dan Deschambault" wrote...
I have a spreadsheet which pulls 3 sets of data from approximately 40
different files.

I need to update the referred path of each cell every week.

Is there a way to make "partial" path names in seperate cells and
essentially create the total path by referring to those cells?
....

Paths are only necessary when referring to closed workbooks. There's no
built-in means of referring into closed workbooks other than by using
external reference links, e.g.,

='C:\Excel\Project\[Test.xls]Sheet1'!$B$2

and such external reference links can't be built by formula directly.

See the following article in the archives for alternatives.

http://groups.google.com/group/micro...443753560f0075