Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9,101
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print Directory to Excel Melody Excel Discussion (Misc queries) 13 September 30th 08 05:53 PM
Searching Excel Directory Mickey Excel Discussion (Misc queries) 1 August 14th 08 09:55 PM
OT :Start your own online business today !start making dollars [email protected] Excel Discussion (Misc queries) 0 May 6th 06 09:29 PM
list directory in EXCEL Bob Phillips Excel Discussion (Misc queries) 1 January 17th 06 04:23 PM
Excel active directory James Setting up and Configuration of Excel 0 April 6th 05 09:00 PM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"