Simple Copy

[WoodyHays]

Why is it that if I copy a formula from a tab in one workbook, that links to another tab in the same workbook, and paste it into another identical workbook that the pasted formula in the target workbook shows a link back to the source workbook?

Example:
In Workbook "Book1" there is a formula on Sheet1 such as +Sheet2!d3. If I copy this formula to workbook "Book2" the resulting formula will read +[Book1]Sheet2!d3. I would want the pasted formula to read +Sheet2!d3.

This "feature" makes it very hard to update a set of identical workbooks from a master template.

Do I have some setting wrong somewhere? Is there a VB workaround to this?

Tnanks,
Woody Hays

[amna77]

Ok here what you have to do.
on the book1, click on cell d3, ok now you see formula on the formula bar, click on the formula bar and right click and copy that formula and press "Esc" key. now you go to sheet 2 and clik cell where you want to paste it, click cell and go to the formala bar and right click and paste, and press enter key.
Try it and see if it works.

[WoodyHays]

Thanks, but that is not really what I am looking for. I need to copy a worksheet with thousands of formulas to hundreds of files.

I guess I will just include find and replace in the routine to mop it up.

Thanks,
Woody Hays