Edit links

Occasional Visitor



I have a master workbook that is linked to workbooks with multiple sheets. I extracted these multiple sheets into separate workbooks. I tried to edit the links but the challenge is the 'Edit links' in Data Tab does not allow for change sources to these multiple sheets in the workbook. Please how do I update the links in the master work book to the newly separated workbook.



1 Reply
I cannot follow. When you extracted / moved (not copied!) those sheets out, the external references would have been created automatically. After that, you should be able to Change Source.