View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick[_2_] Bernie Deitrick[_2_] is offline
external usenet poster
 
Posts: 176
Default edit default excel template

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/