You could also look at using the INDIRECT function, although I would look at
using Change Links first and see if that does what you need.

=INDIRECT("'"&A1&"\[jointdefaults.xls]Defaults'!$C$21")

Assuming C:\TeklaStructuresModels is in cell A1.

When you change the path, you will of course need to open the source
workbook to update all of the links.

"Norm" wrote:

I have a spredsheet that is intended to gather information from another
spreadsheet. So I have linked the cells. The problem is that for each new
project the linked file is the same name, but in a different folder.

I have an if statement in a cell like the one below.

=IF(BoltEdgeDist=-2147483648,'C:\TeklaStructuresModels\[jointdefaults.xls]Defaults'!$C$21,BoltEdgeDist/25.4)

I need to be able to change "'C:\TeklaStructuresModels" to the current
folder. I am collecting the name of the current folder in a cell but I am
not able to replace "'C:\TeklaStructuresModels" with the cell or range name.

Is this possible?