Having problems with where data being got from in a link

[tweacle]

hi

I have 2 workbooks exactly the same and numbered 1 and 2 and saved as 2 seperate workbooks .
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.

[Keebellah]

Well, you know you messed up, you just undo what you did or rebuild it.
Check where the connection is set and edit that section, with the way you explain it and the information offered it's all guessing for us. YOU are the one that knows what you're asking, don't expect others to understand you based on assumptions.
Complete your information like which Office (Excel) version and so, makes it easier for others to see if they can help