Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel start directory
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Directory to Excel | Excel Discussion (Misc queries) | |||
Searching Excel Directory | Excel Discussion (Misc queries) | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
list directory in EXCEL | Excel Discussion (Misc queries) | |||
Excel active directory | Setting up and Configuration of Excel |