How can I make templates available to all users?

[RRinTetons]

Excel 2003, 2007

I've got a directory full of templates I'd like to make available to all users on the network, regardless of what user name they log on with or use to start Excel. I used to be able to find a place where I could specify a path to a nework share where templates could be stored, but darned if I can find where they hid that is Excel 2007.

Is there a single location that will work for both 2003 and 2007, and, if so, where do I specify it?

If not, is there a way to automate the installation of a directory full of templates?


-
Richard Ray
Jackson Hole Mountain Resort

 

[Lilliabeth]

Does this help?

To display network templates in the Word 2007 New Document pane
If you distribute or maintain documents and templates on a network, here's how to display templates you've stored on a network drive in the Word 2007 New Document pane, under My templates:

Open Word, click the Microsoft Office button, and then click Word Options.
Click Advanced, scroll to the General section, and then click File Locations.
Click Workgroup Templates and then click Modify.
Browse to the network share where you store templates, and then click OK.
The next time you click My templates in the new document window, the templates on the network drive will appear. However, they will be displayed with any templates from the user's local template location, or "user templates" location.

On Windows Vista, the default location is C:\Users\USERNAME\AppData\Roaming\Microsoft\Templates. On Windows XP, it is C:\Users\USERNAME\AppData\Microsoft\Templates.

Tip Make sure that everyone who needs to use the templates has access to the network drive, and that it's a secure and trusted location. You might also want to set the network folder properties or the template file properties to read-only so they can't be easily or accidentally modified.

I got it from

http://office.microsoft.com/en-us/templates/HA102373631033.aspx

Lilliabeth
-Why use a big word when a diminutive one will do?-