How do I update links without copy and pasting again.

[shreked12]

HI

I have 2 workbooks exactly the same numbered 1 and 2.
Both have 6 sheets of data and sheet 7 has a summary.

When I open workbook 2 the links where it looking for data is from workbook 1 sheets 1-6 but I need it to look at workbook 2 sheets 1-6 .

I did see something about edit link on a worksheet but completely confused on it.

Any ideas.

 

[Jeffrey Mahoney]

Choose from the Ribbon menu Data - Edit Links - Change Source - Select the current active file.