Hello,

I have created a worksheet template that is saved and  used monthly to
summarize data exported from another db. The cell references in the template
that correlate to the imported 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