Create a report template for importing data

Microsoft Office Excel 2003

previous page next page
  • Format the workbook the way you want it.
  • On the File menu, click Save Button image.
  • In the File name box, type the name for the report.
  • In the Save as type list, click Template.
  • In the Save in list, locate and click the folder you want to store the template in.
  • Click Save.
  • 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.

    • ShowTip

    You can change a report template at any time by opening the report template in Excel and making the changes you want.

    previous page start next page