Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy
 
Posts: n/a
Default is it possible to apply template to a existing worksheet


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default is it possible to apply template to a existing worksheet

What does that mean? An excel template is a regular excel workbook saved as
*.xlt, what it does is that if you open a template it creates a copy of the
template and adds a number so if the template name is Accounting the new
workbook based on it will be called Accounting1.

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Andy" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy
 
Posts: n/a
Default is it possible to apply template to a existing worksheet

I thought you could use a template to format column widths, column heights,
and printing defaults. I have set up a excel spreadsheet and saved it as a
template. Daily I receive spreadsheet from an external source, I want to
change the above attributes on the incoming spreadsheet consistantly,
according to what I have saved in the template.
Andy Lawinger

"Peo Sjoblom" wrote:

What does that mean? An excel template is a regular excel workbook saved as
*.xlt, what it does is that if you open a template it creates a copy of the
template and adds a number so if the template name is Accounting the new
workbook based on it will be called Accounting1.

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Andy" wrote in message
...




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
Macro or OLE method to insert worksheet from template workbook Lyndon Rickards Excel Discussion (Misc queries) 0 January 30th 06 08:46 PM
Insertion of existing worksheets in current worksheet caduser Excel Discussion (Misc queries) 2 November 9th 05 04:55 PM
Transfering a row of data to a template word or worksheet Marc Williams Excel Discussion (Misc queries) 1 October 27th 05 12:33 AM
quickly create extra copies of a worksheet template in a workbook simon Excel Worksheet Functions 2 October 23rd 05 07:04 PM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 06:49 PM


All times are GMT +1. The time now is 01:54 AM.

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

About Us

"It's about Microsoft Excel"