Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Data to a Template | Excel Programming | |||
Importing Data into an Excel sheet-template | Excel Programming | |||
Importing data into specific template cells | Excel Discussion (Misc queries) | |||
Problem with macro for importing data to template | Excel Programming | |||
Importing CSV data into a template or? | Excel Worksheet Functions |