Hello All,
I have a number of workbooks linked together with external references. I have one source workbook with many worksheets in it and two destination workbooks that dependent on it.
When I change the worksheet names in the source workbook, they also change accordingly in one of the destination workbooks but they don`t change in the other destination workbook and the reference just becomes invalid. What is causing this and what do I need to change so that the references in the other destination workbook also update if I change the worksheet names in the source workbook?
Thanks a lot.