Forum Discussion
Changing the link in an external reference
Hi I have a number of liked spreadsheets which need the links updating every year. I assumed I'd be able to change the year reference to the correct year and it would reflect the relevant data but it...
Excel stacks all those references to sheets in external workbooks to one link per external workbook, so links are managed is "per workbook", not "per worksheet". If all that changes is a worksheet name in an external workbook, perhaps it is better to work with a named range *in the external workbook* to which you point in your reporting workbook (the one with the link). If the year changes, you open the SOURCE and change the reference of that name. Alternatively, do a search and replace in your workbook, repacing 2017 Daily Output Figures with 2018 Daily Output Figures.