M
mark
We're looking at the Help for templates in Excel:
1) Format the workbook the way you want it.
2) On the File menu, click Save .
3) In the File name box, type the name for the report.
4) In the Save as type list, click Template.
5) In the Save in list, locate and click the folder you want to store the
template in.
6) Click Save.
7) Do one of the following:
To delete the external data range from the worksheet and automatically
update the data when the report template is opened, click Yes.
To display the current data in the external data range whenever someone
opens a copy of the report template, click No.
<<<<<<<<<<<
We're fine up through 6), but don't see anything in our Excel interface
(Excel 2003) relative to number 7. Where are the Yes/No buttons that it's
saying we should select?
What is wanted, is to have a blank template with formas, and the simplest
way to apply a new set of data to that?
Does anything better than copy/paste exist?
1) Format the workbook the way you want it.
2) On the File menu, click Save .
3) In the File name box, type the name for the report.
4) In the Save as type list, click Template.
5) In the Save in list, locate and click the folder you want to store the
template in.
6) Click Save.
7) Do one of the following:
To delete the external data range from the worksheet and automatically
update the data when the report template is opened, click Yes.
To display the current data in the external data range whenever someone
opens a copy of the report template, click No.
<<<<<<<<<<<
We're fine up through 6), but don't see anything in our Excel interface
(Excel 2003) relative to number 7. Where are the Yes/No buttons that it's
saying we should select?
What is wanted, is to have a blank template with formas, and the simplest
way to apply a new set of data to that?
Does anything better than copy/paste exist?