Problem linking two sheets

[worthm]

Hello,
I use Office 2010 and I'm having a problem. Please see the attached image further down called image. I have two sheet which link to each other. I've made copies of three or four sheets because I liked the formatting on them. I've changed the name, data, etc but I believe this copying is what's causing the issue. Every time I open the sheet I get the pop up to update the links. I follow the screens blow to select the other file location and save. That should resolve it but this happens each time I open the sheet.
135751357613577

When I copied these screens I get messages about linking and I ignored them. How do I fix this issue?

[Paul_Hossler]

I took your AZ XLSM and saved it to a folder

Then I re-saved it as -CA XLSM

Closed both

Opened the AZ XLSM and I got the 'Links' error message about not finding -CA

Selected [Change Source] and pointed it at the -CA XLSM in the folder where I saved it and Excel seems to like it

I don't know if your copying broke something else

13578

[worthm]

Thanks Paul, Im not sure how that fixes it. Isnt it just pointing at itself?

[Paul_Hossler]

Thanks Paul, Im not sure how that fixes it. Isnt it just pointing at itself?

No

The -AZ workbook has links (most likely in WS cells) to a completely different workbook (i.e. the -CA)

Example - Cell T22 in -AZ references a cell in a worksheet in the -CA workbook

It needs to know where to find the -CA workbook

13579