I have a link that works fine:
but I now want to change the referenced workbook based on a cell value...
I have tried:
but this returns #REF where A1 =1
Can you please advise? I am using Excel 2010