excel start directory
Check to see the computers have the network files mapped the same
The easiest way of doing this is to open a Window Expolorer (right click
stat and select explorer). then go to tools - disconnect network drive and
check the network name that is mapped to the z: drive. do not actually
disconnect the drive. if the drives are not mapped the same yo uwill need to
disconnect the Z drive and reconnect so each computer is mapped the same.
The other solution is not to use the Z: as the drive name. Use the Network
path instead
from:
"Z:\[0004] TEMPLATES\EXCEL\START
to
\\networkdrivename\path1\path2\[0004] TEMPLATES\EXCEL\START
where the networkname and path is taken from the path name in the disconnect
menu for drive Z.
"katto01" wrote:
Hello,
I use excel 2003.
I defined "Z:\[0004] TEMPLATES\EXCEL\START" as my excel start
directory.
"Z" drive is a network drive. I am trying to use the same start file
for a number of computers, so I won't have to update many start files.
I have 2 computers on the network. On computer 1, the files existing
in "Z:\[0004] TEMPLATES\EXCEL\START" load (as they should) at start.
On Computer 2, They USED to load (with the warning READ ONLY - which
is fine and reasonable).
Now they don't. I checked the TOOLS/OPTIONS/GENERAL/AT START OPEN
THESE FILES IN and "Z:\[0004] TEMPLATES\EXCEL\START" was there.
Please advise
Also: when I open excel (no workbooks) the TOOLS/OPTIONS is disabled,
however if I open a file it's ENABLED. Is this the way it should be?
Thanks
Tuli01
|