So I work for an accounting firm and most of our work is done in Excel.

Made 2 versions of the same thing I was working on. In my first workbook, I have all of my relevant internal sheet links in place. In my second sheet, I don’t want to go and relink everything. Also, when I copy the link from the first workbook to the second workbook, obviously it links back to workbook 1.

How can I redo all of the links in the second workbook, to link within itself, because it has all of the same reference points.

I tried copying the link from the first workbook and pasting that in the second workbook.

e.g. link in workbook 1
=!TB15

link in workbook 2
=![workbook1]TB15

How do I remove that part where it links to the first workbook and rather within the second workbook links within itself in the quickest way?

I’ve taken this
link in workbook 2
=![workbook1]TB15

and removed the ![workbook1] portion so then the link in 2nd workbook is also
=!TB15
which works, but takes way too long to do it for all of the cells I have to work with.