ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Workgroup templates in Excel 2007 (https://www.excelbanter.com/setting-up-configuration-excel/185778-workgroup-templates-excel-2007-a.html)

hmm

Workgroup templates in Excel 2007
 
I remember in Excel 2000 specifying a location where my company's templates
are located on the local network, and these would be among the templates
selectable when creating a new document.

Does this feature exist in Excel 2007? If so, how do I specify the
templates' folder location? If not, how else can I achieve the same thing?

(Incidentally, a search of "workgroup template" in Help yielded no exact
matches.)

Thanks.

Rich Text

Workgroup templates in Excel 2007
 
I'm having the same experience in Excel 2003, but can offer a workaround. The
workgroup template location can be set in Microsoft Word. (Tools, Options,
File Locations tab), but Excel won't use the templates on a network drive.
Make (and keep updated) a briefcase copy of the workgroup templates on your
local machine then set the workgroup templates location to that briefcase
copy, using Word to set it. Excel will then see the templates in you
briefcase when you ask for a new workbook using templates "On my computer..."

"hmm" wrote:

I remember in Excel 2000 specifying a location where my company's templates
are located on the local network, and these would be among the templates
selectable when creating a new document.

Does this feature exist in Excel 2007? If so, how do I specify the
templates' folder location? If not, how else can I achieve the same thing?

(Incidentally, a search of "workgroup template" in Help yielded no exact
matches.)

Thanks.



All times are GMT +1. The time now is 11:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com