如何在Excel中对另一个工作簿进行相对引用?

I am producing a sheet to calculate prices. The sheet has to have a reference to several other workbooks to get the prices for different components. This works fine on my computer but when I move them to the server or another computer, it can't find the references.I am producing a sheet to calculate prices. The