Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 27th 09, 03:50 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 20
Default Is there a settings startup file for Excel?

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?

  #2   Report Post  
Old September 27th 09, 04:57 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Is there a settings startup file for Excel?

Open a new workbook. Customize as you wish.........group the sheets before
setup so's all sheets get same settings.

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).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 07:50:02 -0700, JimG
wrote:

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?


  #3   Report Post  
Old September 27th 09, 06:02 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 20
Default Is there a settings startup file for Excel?

Gord
Thanks ... worked like a charm.
Any ideas about my other excel post this am? "Disable column only sorting
in Excel"

Jim

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.........group the sheets before
setup so's all sheets get same settings.

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).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 07:50:02 -0700, JimG
wrote:

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?



  #4   Report Post  
Old September 27th 09, 06:19 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Is there a settings startup file for Excel?

Unfortunately, there is no "beforesort" event so you cannot cancel the sort
if not all pertinent columns are selected.

I agree with Dave about creating a Table from your range as the easist
method to control the sort range.


Gord

On Sun, 27 Sep 2009 10:02:01 -0700, JimG
wrote:

Gord
Thanks ... worked like a charm.
Any ideas about my other excel post this am? "Disable column only sorting
in Excel"

Jim

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.........group the sheets before
setup so's all sheets get same settings.

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).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 07:50:02 -0700, JimG
wrote:

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?




  #5   Report Post  
Old September 27th 09, 06:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Is there a settings startup file for Excel?

On the other hand you could run Sort from a button to which a macro is
assigned.

But you could still have users who bypassed that and ran sort from regular
method or disabled macros on opening.


Gord

On Sun, 27 Sep 2009 10:19:37 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Unfortunately, there is no "beforesort" event so you cannot cancel the sort
if not all pertinent columns are selected.

I agree with Dave about creating a Table from your range as the easist
method to control the sort range.


Gord

On Sun, 27 Sep 2009 10:02:01 -0700, JimG
wrote:

Gord
Thanks ... worked like a charm.
Any ideas about my other excel post this am? "Disable column only sorting
in Excel"

Jim

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.........group the sheets before
setup so's all sheets get same settings.

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).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 07:50:02 -0700, JimG
wrote:

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?





  #6   Report Post  
Old September 27th 09, 09:24 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 20
Default Is there a settings startup file for Excel?

I think we are going to include a warning/disclaimer page or popup with our
outbound data spreadsheets. Thanks for your help.

If you have Word / Access expertise, please take a look at my other post
this am listed under "Word" - "Mailmerge" titled "How do you connect Word
2003 to Access 2007 accdb database"

Jim

"Gord Dibben" wrote:

On the other hand you could run Sort from a button to which a macro is
assigned.

But you could still have users who bypassed that and ran sort from regular
method or disabled macros on opening.


Gord

On Sun, 27 Sep 2009 10:19:37 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Unfortunately, there is no "beforesort" event so you cannot cancel the sort
if not all pertinent columns are selected.

I agree with Dave about creating a Table from your range as the easist
method to control the sort range.


Gord

On Sun, 27 Sep 2009 10:02:01 -0700, JimG
wrote:

Gord
Thanks ... worked like a charm.
Any ideas about my other excel post this am? "Disable column only sorting
in Excel"

Jim

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.........group the sheets before
setup so's all sheets get same settings.

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).

Instructions are for Excel 2003 and earlier.

2007 is similar except you would save as BOOK.xltx


Gord Dibben MS Excel MVP


On Sun, 27 Sep 2009 07:50:02 -0700, JimG
wrote:

I create hundreds of excel spreadsheets and would like excel to startup with
the following settings:
1. Alignment - Vertical set to "Top"
2. Default number field set to number with 2 decemal places and a comma.
3 Text Control - Wrap = Off

The current default vertical allignment set to Bottom and wrap on causes
information display problems. To a novice user a cell can appear to be
empty.

Is there a startup settings file that can be changed for Excel or some
secret setting within Excel to do the above? If so, how?






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
Can Excel automatically open a defaul file on startup? artistdave Setting up and Configuration of Excel 1 March 11th 08 08:09 AM
automatically opening an excel file on startup NanTan Excel Discussion (Misc queries) 3 November 10th 06 08:55 PM
Change Startup Settings Slave2Six Excel Discussion (Misc queries) 4 August 1st 06 08:03 PM
Where does Excel get the default properties without startup file? Questions from Christine Excel Discussion (Misc queries) 2 July 6th 05 07:47 PM
2003 Excel isn't reading the book.xlt file on startup. rlweaver007 Excel Discussion (Misc queries) 1 March 15th 05 10:26 AM


All times are GMT +1. The time now is 08:11 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017