Prevent Outside Links?

[Thomas5000]

Is it possible to prevent or paste formulars to a workbook without the links changing?

The problem is all of my links are only supposed to link ot pages within the current workbook. However, i have to create numerous copies of the workbook--one for each month of the year. What happens is that the formulas will change, trying to link to the original work book. IS there a way to keep the formulas from changing? I want them to remain exactly the way they are before changing the file name. If i only had to change the file name i would be happy. But what happens is that the formulas will try to link to the original file. I don't want this.

Thanks!

 

[Gavona]

To solve the issue create your workbook as now. Save it.
Then:
Edit, Links, ChangeSource and point to the workbook you are in.




Gavin