Question about re-naming and moving linked workbooks

[Yoshi64]

So I understand excel has some intelligence with this, but through trial-and-error I'm still having some difficulty understanding what I can and cannot do.

I'm creating a workbook called SalesWeekX.xlsm and another workbook called SummaryWeekX.xlsm

The Summary workbook imports lots of data from the Sales workbook, so many cells have references such as [SalesWeek1.xlsm]Sales!A1

Each week I want to save the template workbooks for the respective week. So after 10 weeks I would have 20 total workbooks. The problem is if I change the name of SalesWeekX to SalesWeek4, my references will (presumably) be get screwed up. Is there a way so I can rename a referenced workbook and have the Summary workbook still find the correct file? (much like the way you can rename tabs and excel will change your references accordingly within a workbook)

[FDibbins]

If both files are open when you rename the week file, the summary file will change it's links accordingly. You can then save both and the links will be updated

[Yoshi64]

Ok thanks, it was the part about them both being open which I didn't understand.

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)