Hi all,

Is there a syntax to make the path of a linked cell dynamic? I値l explain with an example:

Cell A1 is linked to another excel file, example.xls, in the folder week 40.
So the formula in cell A1: ='C:\week 40\[example.xls]Blad1'!$A$1

In this formula, I want the value 40 to be dynamic, and read this value from cell B1.
So lets say I put 41 in to cell B1, the formula in cell A1 should read ='C:\week 41\[example.xls]Blad1'!$A$1

Any way to go about this? Thanks a lot in advance!

Cheers, Chris