Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 989
Default Importing Data to a Template

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Data to a Template mark Excel Programming 0 February 6th 09 08:45 PM
Importing Data into an Excel sheet-template spacemancw Excel Programming 5 June 26th 08 01:58 PM
Importing data into specific template cells Ron Excel Discussion (Misc queries) 0 July 11th 06 07:24 PM
Problem with macro for importing data to template Jay_B Excel Programming 3 June 13th 06 08:54 AM
Importing CSV data into a template or? Alberto Excel Worksheet Functions 3 October 28th 05 07:41 PM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"