excel start directory

  • Thread starter Thread starter katto01
  • Start date Start date
K

katto01

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
 
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.
 
Back
Top