You can't have a variable/dynamic link to a closed workbook. You would need
a macro that makes the adjustment by hardcoding the link.

--
Regards,
Tom Ogilvy

"SB1979" wrote in message
...
This is what I am trying to do:

e.g. A cell has the following reference:
='G:\Finance\Tax\7-1 Plan\P1

I want to change it to:

='G:\Finance\Tax\10-1 Plan\P1

so that '7-1 Plan' or '10-1 Plan' is the reference cell in another
workbook.

Thanks!

SB