I have createded a worksheet template that is saved and used monthly to summarize data exported from another db. The cell references in the template that coralate to the importated data never change nor do the names of the imported worksheets. The problem I have is when I copy my template to the new workbook with the next months data and recalc, I still get ref errors. I have to manually click into each cell / formula to eliminate the err and get the data. Is there a way to have this information updated automatically when I copy my template into the new workbook? Thanks, Greg Y
