Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formuals | Excel Discussion (Misc queries) | |||
New to Formuals | Excel Worksheet Functions | |||
excel conditional formuals | Excel Worksheet Functions | |||
how is Insert, Name, Label different frm Accept labels in formula | Excel Discussion (Misc queries) | |||
mail merge will not accept zip codes that start with a zero "label | Excel Discussion (Misc queries) |