T
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?
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?