Lauren said:
Thank you for getting back to me so quickly. I'm sorry, I forgot the most
important part of the question. My template is several worksheets. When I
open the template on a new excel sheet thats fine. The zeros appear when I
click special link after copying the last worksheet of the template to a
new
workbook (that is the sum of all the seperate workbooks)..any advice?
You shouldn't need to copy anything. If you have saved the amended template
properly as a template, then when you create a new document from that
template it should all be there.
In fact Ive just created a template from a multi-sheet workbook and whan I
go to New-Template and open a document based on that template, it's all
there.