Accept Label in Formuals
 

Is There any way to Select permanently Accept label in Formulas in Excel

Tools <Options<Calculations<Check Accept Labels in Formulas

Every time i have to Check This Option.

Even when i Check this Option in 1 Sheet and i open the Another Workbook i
have to Check this option in also in that Sheet.

Thanks

Hardeep kanwar

Accept Label in Formuals
 

Close all sessions of XL. Open up a new session. Make any changes you want to
the options. Close.

This should preserve any changes you made and apply them across all sessions
now.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hardeep_kanwar" wrote:

Is There any way to Select permanently Accept label in Formulas in Excel

Tools <Options<Calculations<Check Accept Labels in Formulas

Every time i have to Check This Option.

Even when i Check this Option in 1 Sheet and i open the Another Workbook i
have to Check this option in also in that Sheet.

Thanks

Hardeep kanwar

Accept Label in Formuals
 

That is a workbook setting, not a global setting.

You can re-define the default Excel NewWorkbook so's the setting will be
enabled when you open a new workbook.

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 MS Excel MVP

On Tue, 13 Jan 2009 07:33:01 -0800, Hardeep_kanwar
wrote:

Is There any way to Select permanently Accept label in Formulas in Excel

Tools <Options<Calculations<Check Accept Labels in Formulas

Every time i have to Check This Option.

Even when i Check this Option in 1 Sheet and i open the Another Workbook i
have to Check this option in also in that Sheet.

Thanks

Hardeep kanwar

Accept Label in Formuals
 

Thank Sir

For your Valuable Tips

"Luke M" wrote:

Close all sessions of XL. Open up a new session. Make any changes you want to
the options. Close.

This should preserve any changes you made and apply them across all sessions
now.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hardeep_kanwar" wrote:

Is There any way to Select permanently Accept label in Formulas in Excel

Tools <Options<Calculations<Check Accept Labels in Formulas

Every time i have to Check This Option.

Even when i Check this Option in 1 Sheet and i open the Another Workbook i
have to Check this option in also in that Sheet.

Thanks

Hardeep kanwar

Accept Label in Formuals
 

Thank Sir

For your Valuable Tips

Hardeep kanwar

"Gord Dibben" wrote:

That is a workbook setting, not a global setting.

You can re-define the default Excel NewWorkbook so's the setting will be
enabled when you open a new workbook.

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 MS Excel MVP

On Tue, 13 Jan 2009 07:33:01 -0800, Hardeep_kanwar
wrote:

Is There any way to Select permanently Accept label in Formulas in Excel

Tools <Options<Calculations<Check Accept Labels in Formulas

Every time i have to Check This Option.

Even when i Check this Option in 1 Sheet and i open the Another Workbook i
have to Check this option in also in that Sheet.

Thanks

Hardeep kanwar