Saving values Cathy W 19.12.2005 19:59:02 Hello. I have a template that I populate from another workbook using formulas. As any template, when you double click the template it renames it appends a 1 to the end of the filename and treats it as a .xls file. I need code that will change all formulas to values and need to know where this code goes in the template so that the forumlas in my template don't get overwritten with values. I also need to know how to save this file with just the values and no code behind. Hope someone can help. Cathy