D
David
I have a situation with many users mapped to the same server under various
'drive letters' Lets say the server name is 'abcd\'. when users map to
network drive they may get 'X:\' or 'Y:\' or 'Z:\'. They will see
adcd\MyDatabasefolder:\.. as Z:\MyDatabaseFolder\.. etc. I need to force
'abcd\MyDatabaseFolder\' as the pathname when setting up the data source for
the pivot table so that all users can refresh the pivot table via a valid
path regardless of which drive letter has been aloocated on their machine. I
suspect there is a convention for naming the path that I am not aware of.
I've tried the obvious, but no luck so far
Any ideas?
'drive letters' Lets say the server name is 'abcd\'. when users map to
network drive they may get 'X:\' or 'Y:\' or 'Z:\'. They will see
adcd\MyDatabasefolder:\.. as Z:\MyDatabaseFolder\.. etc. I need to force
'abcd\MyDatabaseFolder\' as the pathname when setting up the data source for
the pivot table so that all users can refresh the pivot table via a valid
path regardless of which drive letter has been aloocated on their machine. I
suspect there is a convention for naming the path that I am not aware of.
I've tried the obvious, but no luck so far
Any ideas?