Relative link or bust

Hello everyone, I'm working on a workbook that will be used as part of a project template where information from another workbook in the project template folder is used to make calculations and save time making duplicate entries. I'm trying to figure out how to make Excel quit changing the links to absolute file path, which would mess things up if a new project were started and the links pointed back to the workbooks in the template folder, rather than the workbook in the active project folder. So what I would like to have is these external references use only relative links, and return an error if it encounters an issue, rather than automatically try to update and start pointing to a workbook of the same name in a wrong folder.

All it needs to do is copy over values entered into certain cells, so it's a very simple operation. I looked through the forum for previous threads on this issue and came up with someone suggesting using the HYPERLINK, and FIND function, but that seems to be intended for opening the referenced workbook to a particular cell?

Originally Posted by 6StringJazzer

Helpful answer

Ah! This helps tremendously, thank you. I didn't know Excel was so dynamic, I guess you could say, with its links. We take the template folder the Excel workbooks are stored in and copy, paste, and then rename it to the new active project so then as you've explained it should behave how I want it to.