I have some users who used the xlusrgal.xls file stored in
C:\Documents and Settings\<user name\Application Data\Microsoft\excel
to store their own chart templates in Excel 2003.

This doesn't seem to work in Excel 2007, and I see they have replaced it by
Chart templates (.crtx). These chart templates need to be stored in a
'Charts' folder underneath the regular template path.

The issue I have is that we lock down the template path for the firm (both
user and shared), but we want to allow users to create their own chart
templates by storing them to their profile as they could in 2003.

Any suggestions?

I'm sorry for having THE solution but I share your problem and don't seem to
have found almost anything about it. The closest I got to was the following
link but I haven't tried it out yet with 2007:

http://groups.google.com/group/micro...0f8a219326de1a

"Bee" wrote:

I have some users who used the xlusrgal.xls file stored in
C:\Documents and Settings\<user name\Application Data\Microsoft\excel
to store their own chart templates in Excel 2003.

This doesn't seem to work in Excel 2007, and I see they have replaced it by
Chart templates (.crtx). These chart templates need to be stored in a
'Charts' folder underneath the regular template path.

The issue I have is that we lock down the template path for the firm (both
user and shared), but we want to allow users to create their own chart
templates by storing them to their profile as they could in 2003.

Any suggestions?