Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Book Template
Any workbook, template (template: A workbook that you create and use as the
basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.), or workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places: C:\Documents and Settings\username\Application Data\Microsoft\Excel C:\Program Files\Microsoft Office\Office11 HTH "goss" wrote: Hi all - I would like to create a template so that when I Ctrl+N on the keyboard I receive a new Book with my custom configuration (Zoom, Color Pallete, Gridlines) I tried modifying Book1.xlt and resaving it in the same location I found it C:\Documents and Settings\goss\Application Data\Microsoft\Templates I searched the PC, this is the only instance of Book1.xlt (Also ... \goss\recent) Using Office 11 Checked XLStart, it is empty Unloaded all add-ins Re-launched Excel but the standard Book1 is given, not my custom version. What else can I check into? Thanks -goss |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Book Template
On Apr 11, 10:12 am, ufo_pilot
wrote: Any workbook, template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.), or workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places: C:\Documents and Settings\username\Application Data\Microsoft\Excel C:\Program Files\Microsoft Office\Office11 HTH "goss" wrote: Hi all - I would like to create a template so that when I Ctrl+N on the keyboard I receive a new Book with my custom configuration (Zoom, Color Pallete, Gridlines) I tried modifying Book1.xlt and resaving it in the same location I found it C:\Documents and Settings\goss\Application Data\Microsoft\Templates I searched the PC, this is the only instance of Book1.xlt (Also ... \goss\recent) Using Office 11 Checked XLStart, it is empty Unloaded all add-ins Re-launched Excel but the standard Book1 is given, not my custom version. What else can I check into? Thanks -goss- Hide quoted text - - Show quoted text - Thanks. My confusion comes from the fact that nothing is in xlstart at the moment Yet when I fire-up Excel I receive Book1, but it is not my Book1.xlt (path given above at start of thread) So where is this Book1.xls coming from? I checked the default location (C:\Data\Excel - Hey, it's a company laptop) Nothing there named "Book1.xls" Nothing in XLStart folder (Only 1 XLStart folder I checked) All add-ins are unloaded Thanks -goss |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Book Template
Start over.
Open a new workbook. Customize as you wish. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew or the Toolbar button FileNew or CTRL + n WARNING................Do not use FileNew...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On 11 Apr 2007 10:35:00 -0700, "goss" wrote: On Apr 11, 10:12 am, ufo_pilot wrote: Any workbook, template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.), or workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places: C:\Documents and Settings\username\Application Data\Microsoft\Excel C:\Program Files\Microsoft Office\Office11 HTH "goss" wrote: Hi all - I would like to create a template so that when I Ctrl+N on the keyboard I receive a new Book with my custom configuration (Zoom, Color Pallete, Gridlines) I tried modifying Book1.xlt and resaving it in the same location I found it C:\Documents and Settings\goss\Application Data\Microsoft\Templates I searched the PC, this is the only instance of Book1.xlt (Also ... \goss\recent) Using Office 11 Checked XLStart, it is empty Unloaded all add-ins Re-launched Excel but the standard Book1 is given, not my custom version. What else can I check into? Thanks -goss- Hide quoted text - - Show quoted text - Thanks. My confusion comes from the fact that nothing is in xlstart at the moment Yet when I fire-up Excel I receive Book1, but it is not my Book1.xlt (path given above at start of thread) So where is this Book1.xls coming from? I checked the default location (C:\Data\Excel - Hey, it's a company laptop) Nothing there named "Book1.xls" Nothing in XLStart folder (Only 1 XLStart folder I checked) All add-ins are unloaded Thanks -goss |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Book Template
On Apr 11, 12:57 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Start over. Open a new workbook. Customize as you wish. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew or the Toolbar button FileNew or CTRL + n WARNING................Do not use FileNew...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On 11 Apr 2007 10:35:00 -0700, "goss" wrote: On Apr 11, 10:12 am, ufo_pilot wrote: Any workbook, template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.), or workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places: C:\Documents and Settings\username\Application Data\Microsoft\Excel C:\Program Files\Microsoft Office\Office11 HTH "goss" wrote: Hi all - I would like to create a template so that when I Ctrl+N on the keyboard I receive a new Book with my custom configuration (Zoom, Color Pallete, Gridlines) I tried modifying Book1.xlt and resaving it in the same location I found it C:\Documents and Settings\goss\Application Data\Microsoft\Templates I searched the PC, this is the only instance of Book1.xlt (Also ... \goss\recent) Using Office 11 Checked XLStart, it is empty Unloaded all add-ins Re-launched Excel but the standard Book1 is given, not my custom version. What else can I check into? Thanks -goss- Hide quoted text - - Show quoted text - Thanks. My confusion comes from the fact that nothing is in xlstart at the moment Yet when I fire-up Excel I receive Book1, but it is not my Book1.xlt (path given above at start of thread) So where is this Book1.xls coming from? I checked the default location (C:\Data\Excel - Hey, it's a company laptop) Nothing there named "Book1.xls" Nothing in XLStart folder (Only 1 XLStart folder I checked) All add-ins are unloaded Thanks -goss- Hide quoted text - - Show quoted text - Thanks Gord Works great! Any way to get same result w/o BOOK1 opening when I launch Excel? Thanks -goss |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
New Book Template
On Apr 21, 6:51 pm, goss wrote:
On Apr 11, 12:57 pm, Gord Dibben <gorddibbATshawDOTca wrote: Start over. Open a new workbook. Customize as you wish. FileSave As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT. Store this workbook in the XLSTART folder usually located at........ C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART This will be the default workbook for FileNew or the Toolbar button FileNew or CTRL + n WARNING................Do not use FileNew...Blank Workbook or you will get the Excel default workbook. NOTE: Existing workbooks are not affected by these settings. You can also open a new workbook and delete all but one sheet. Customize as you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes the default InsertSheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On 11 Apr 2007 10:35:00 -0700, "goss" wrote: On Apr 11, 10:12 am, ufo_pilot wrote: Any workbook, template (template: A workbook that you create and use as the basis for other similar workbooks. You can create templates for workbooks and worksheets. The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.), or workspace file (workspace file: A file that saves display information about open workbooks, so that you can later resume work with the same window sizes, print areas, screen magnification, and display settings. A workspace file doesn't contain the workbooks themselves.) you place in the XLStart folder is automatically opened when you start Excel. This XLStart folder was created when you installed Excel, and is located in one of the following places: C:\Documents and Settings\username\Application Data\Microsoft\Excel C:\Program Files\Microsoft Office\Office11 HTH "goss" wrote: Hi all - I would like to create a template so that when I Ctrl+N on the keyboard I receive a new Book with my custom configuration (Zoom, Color Pallete, Gridlines) I tried modifying Book1.xlt and resaving it in the same location I found it C:\Documents and Settings\goss\Application Data\Microsoft\Templates I searched the PC, this is the only instance of Book1.xlt (Also ... \goss\recent) Using Office 11 Checked XLStart, it is empty Unloaded all add-ins Re-launched Excel but the standard Book1 is given, not my custom version. What else can I check into? Thanks -goss- Hide quoted text - - Show quoted text - Thanks. My confusion comes from the fact that nothing is in xlstart at the moment Yet when I fire-up Excel I receive Book1, but it is not my Book1.xlt (path given above at start of thread) So where is this Book1.xls coming from? I checked the default location (C:\Data\Excel - Hey, it's a company laptop) Nothing there named "Book1.xls" Nothing in XLStart folder (Only 1 XLStart folder I checked) All add-ins are unloaded Thanks -goss- Hide quoted text - - Show quoted text - Thanks Gord Works great! Any way to get same result w/o BOOK1 opening when I launch Excel? Thanks -goss- Hide quoted text - - Show quoted text - For this to work, I have discovered that I must launch the Excel application first and then browse to open a file Habitually I use a file manager program, find the Excel file I need and 2x click the file I notice whwn I use this approach, any new workbooks revert to the standard template Only by launching the Excel app first do I receive BOOK1.XLT the template I created. Thanks -goss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looking for a price book template | Excel Discussion (Misc queries) | |||
Where is excel address book template? | Excel Discussion (Misc queries) | |||
Check book register template | New Users to Excel | |||
Purchase Book template | New Users to Excel | |||
How do I get a Template to write a Book ? | New Users to Excel |