Karen,
Open whatever file is automatically loaded at startup in the default
XLStart folder, make the changes to your Tools | Options..., then save
that file. If it is a blank book, then open/save Book.xlt - make sure
you save it as an Excel template.
Excel's default settings are set by the first file that is opened.
HTH,
Bernie
MS Excel MVP
"kefranks" wrote in message
...
Hi, we have several users using Excel in a terminal services\Citrix
environment. I need to change a setting in the default excel
template
so that every time a user starts excel, they have a particular
setting
set.
The setting they need is under tools\options, then on the
Calculation
tab, they need the 'Accept labels in formulas' option to be ticked
(which it isn't by default).
What do I need to do to enable this for all users in a multi-user
environment?
All suggestions greatly appreciated.
Thanks,
Karen
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/