*Slightly OT* - SBS4.5 > SBS2k - Excel XP won't see workgroup templates?

[David Elders]

Hi again,

Very weird one here.

Had SBS4.5 - backed up all data - flattened server - clean install of
SBS2k - restored data - shares with same names/locations created

LAN clients running Office 2000 can use workgroup templates exactly as they
could previously
LAN clients running Office XP can use workgroup templates fine in Word but
not in Excel - simply don't appear! Can browse to the relevant template
files and open them directly OK however.

Have even tried moving the template files to an entirely new folder with the
shares being custom created so as to ensure that none of the 'old' security
and/or access level permissions of the 'previous' server were copied across.
Then used login script to map a network drive to this new folder. Pointed
the Options/General tab in Excel to have the 'At statup, open all files in:'
entry pointing to this new mapped drive.

No change.

Starting to pull hair out. Settings are identical on both the Office 2k and
Office XP Excel clients but the XP ones simply won't use the workgroup
templates. The Excel XP clients are new - all clients were Office 2k before
SBS upgrade...

Anyone got any bright ideas?

Thanks in advance,



David

 

[Cris Hanna [SBS - MVP]]

David
I doubt that this has anything specifically to do with the upgrade.
but I'm thinking you may wanna poke around in the Office setup NG and see if anyone there has a thought (although you may get some response from the other groups you've posted to as well)

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that all can benefit.
Hi again,

Very weird one here.

Had SBS4.5 - backed up all data - flattened server - clean install of
SBS2k - restored data - shares with same names/locations created

LAN clients running Office 2000 can use workgroup templates exactly as they
could previously
LAN clients running Office XP can use workgroup templates fine in Word but
not in Excel - simply don't appear! Can browse to the relevant template
files and open them directly OK however.

Have even tried moving the template files to an entirely new folder with the
shares being custom created so as to ensure that none of the 'old' security
and/or access level permissions of the 'previous' server were copied across.
Then used login script to map a network drive to this new folder. Pointed
the Options/General tab in Excel to have the 'At statup, open all files in:'
entry pointing to this new mapped drive.

No change.

Starting to pull hair out. Settings are identical on both the Office 2k and
Office XP Excel clients but the XP ones simply won't use the workgroup
templates. The Excel XP clients are new - all clients were Office 2k before
SBS upgrade...

Anyone got any bright ideas?

Thanks in advance,



David

 

[David Elders]

Hi all,

Sussed it [finally!] - you're right, as suspected it wasn't to do directly
with the upgrade - more mentioned it just in case!

Office XP - you have to set the workgroup templates location within Word and
this setting applies to ALL Office XP programs. Means you have to put Word,
Excel, whatever templates in the same location but that's not a big deal -
our issue was that we had previously had separate folders for Word, Excel
etc so Excel was looking in the Word folder...

Be nice if MS had made this a little clearer but all's well that ends well!

Cheers,



David


David
I doubt that this has anything specifically to do with the upgrade.
but I'm thinking you may wanna poke around in the Office setup NG and see if
anyone there has a thought (although you may get some response from the
other groups you've posted to as well)

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that
all can benefit.
Hi again,

Very weird one here.

Had SBS4.5 - backed up all data - flattened server - clean install of
SBS2k - restored data - shares with same names/locations created

LAN clients running Office 2000 can use workgroup templates exactly as they
could previously
LAN clients running Office XP can use workgroup templates fine in Word but
not in Excel - simply don't appear! Can browse to the relevant template
files and open them directly OK however.

Have even tried moving the template files to an entirely new folder with the
shares being custom created so as to ensure that none of the 'old' security
and/or access level permissions of the 'previous' server were copied across.
Then used login script to map a network drive to this new folder. Pointed
the Options/General tab in Excel to have the 'At statup, open all files in:'
entry pointing to this new mapped drive.

No change.

Starting to pull hair out. Settings are identical on both the Office 2k and
Office XP Excel clients but the XP ones simply won't use the workgroup
templates. The Excel XP clients are new - all clients were Office 2k before
SBS upgrade...

Anyone got any bright ideas?

Thanks in advance,



David

 

[Cris Hanna [SBS - MVP]]

Glad to hear you found it.

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that all can benefit.
Hi all,

Sussed it [finally!] - you're right, as suspected it wasn't to do directly
with the upgrade - more mentioned it just in case!

Office XP - you have to set the workgroup templates location within Word and
this setting applies to ALL Office XP programs. Means you have to put Word,
Excel, whatever templates in the same location but that's not a big deal -
our issue was that we had previously had separate folders for Word, Excel
etc so Excel was looking in the Word folder...

Be nice if MS had made this a little clearer but all's well that ends well!

Cheers,



David


David
I doubt that this has anything specifically to do with the upgrade.
but I'm thinking you may wanna poke around in the Office setup NG and see if
anyone there has a thought (although you may get some response from the
other groups you've posted to as well)

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that
all can benefit.
Hi again,

Very weird one here.

Had SBS4.5 - backed up all data - flattened server - clean install of
SBS2k - restored data - shares with same names/locations created

LAN clients running Office 2000 can use workgroup templates exactly as they
could previously
LAN clients running Office XP can use workgroup templates fine in Word but
not in Excel - simply don't appear! Can browse to the relevant template
files and open them directly OK however.

Have even tried moving the template files to an entirely new folder with the
shares being custom created so as to ensure that none of the 'old' security
and/or access level permissions of the 'previous' server were copied across.
Then used login script to map a network drive to this new folder. Pointed
the Options/General tab in Excel to have the 'At statup, open all files in:'
entry pointing to this new mapped drive.

No change.

Starting to pull hair out. Settings are identical on both the Office 2k and
Office XP Excel clients but the XP ones simply won't use the workgroup
templates. The Excel XP clients are new - all clients were Office 2k before
SBS upgrade...

Anyone got any bright ideas?

Thanks in advance,



David

 

[David Elders]

It actually makes a kind of sense - just be nice if it was more clearly
defined/worded in the programs. After all, it's unlikely that a
user/administrator's initial thought would be to check if a Word setting
would apply to Excel. Still, saves doing it multiple times now that I know
about it!

Cheers,


David


Glad to hear you found it.

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that
all can benefit.
Hi all,

Sussed it [finally!] - you're right, as suspected it wasn't to do directly
with the upgrade - more mentioned it just in case!

Office XP - you have to set the workgroup templates location within Word and
this setting applies to ALL Office XP programs. Means you have to put Word,
Excel, whatever templates in the same location but that's not a big deal -
our issue was that we had previously had separate folders for Word, Excel
etc so Excel was looking in the Word folder...

Be nice if MS had made this a little clearer but all's well that ends well!

Cheers,



David


David
I doubt that this has anything specifically to do with the upgrade.
but I'm thinking you may wanna poke around in the Office setup NG and see if
anyone there has a thought (although you may get some response from the
other groups you've posted to as well)

--
Cris Hanna [SBS - MVP]
Please DO NOT email me directly but respond only in the newsgroup so that
all can benefit.
Hi again,

Very weird one here.

Had SBS4.5 - backed up all data - flattened server - clean install of
SBS2k - restored data - shares with same names/locations created

LAN clients running Office 2000 can use workgroup templates exactly as they
could previously
LAN clients running Office XP can use workgroup templates fine in Word but
not in Excel - simply don't appear! Can browse to the relevant template
files and open them directly OK however.

Have even tried moving the template files to an entirely new folder with the
shares being custom created so as to ensure that none of the 'old' security
and/or access level permissions of the 'previous' server were copied across.
Then used login script to map a network drive to this new folder. Pointed
the Options/General tab in Excel to have the 'At statup, open all files in:'
entry pointing to this new mapped drive.

No change.

Starting to pull hair out. Settings are identical on both the Office 2k and
Office XP Excel clients but the XP ones simply won't use the workgroup
templates. The Excel XP clients are new - all clients were Office 2k before
SBS upgrade...

Anyone got any bright ideas?

Thanks in advance,



David