How to save formulas while copying worksheet?

[Tech.Zoan]

I'm trying to copy a worksheet i created as a template as a new
worksheet in another workbook without having my formulas change in the
process.

I have tried all the pasting options and all the formulas get change
from ex.: =Material!A4 to ='[Template.xls]Material'!A4

In other words, reference to the template file are added to the
formulas but i don't want that... i just want the copy the original
formulas as they appear in the template.

Any way of doing this or will i have to copy and paste and then edit
all the affected formulas to remove any reference to the template
file?

 

[Dave Peterson]

I like to change the formulas to text:

Select all the cells
edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Then do the copy

Then reverse that edit|replace in the original worksheet and the new copy.

I'm trying to copy a worksheet i created as a template as a new
worksheet in another workbook without having my formulas change in the
process.

I have tried all the pasting options and all the formulas get change
from ex.: =Material!A4 to ='[Template.xls]Material'!A4

In other words, reference to the template file are added to the
formulas but i don't want that... i just want the copy the original
formulas as they appear in the template.

Any way of doing this or will i have to copy and paste and then edit
all the affected formulas to remove any reference to the template
file?