Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 28th 05, 10:34 PM
Steve Jackson
 
Posts: n/a
Default 2 DFS Mapped drives confuses active links in Excel

I have a user created in Active Directory and logging into an XP Pro PC and
using Excel XP. He created an Excel 97 spreadsheet with active links to
other Excel spreadsheets when he was on NT. In Office 97 the link was
created with specifically a drive letter of H: to the location of the data
(e.g H:\Data\SectionA\excel spreadsheet.xls).

Since this user was migrated to XP last year and updated some of the links
it now links as the full DFS path to the data. This is fine apart from now a
data group has been created in Active Directory that maps a H: drive along
the DFS structure further onto the physical server 2 levels in (i.e DFS
starts at "\shared" for J: and "Shared\Data\SectionA\" for H. The H: drive
is required to run a database and needs to be H: for legacy reasons so this
cannot be changed.

The problem is that Excel gets confused between the 2 DFS drive mappings.
When the link is created it is created as per the H: drive DFS (not a
physical drive mapping). Some time later after the spreadsheet has been
opened and closed several times it tries to find the linked files as per the
J: drive DFS mapping and thus the links are set up incorrectly (2 levels
different as per the difference between the H: and J: drives).

The question really is:
- How can I force Excel to keep the specific active links either:
a) As a specific drive letter and specific path to the other speadsheets,
or;
b) As a DFS link but keep either the H: drive mapping DFS or the J: mapping
DFS

I cannot find an option of how to change how the link is created and if this
is intermitent I cannot determine why this is happening. Can this be the
case that other people get into the file but traversing through the J:
drive, making updates, which then confuses Excel? It seems to be a problem
with how Excel interprets the DFS mappings for the active links between the
spreadsheets.

If anyone can help it will be greatly apreciated.

Steve



  #2   Report Post  
Old July 29th 05, 08:10 AM
Bill Manville
 
Posts: n/a
Default

It may depend on the location of the workbook.
I think it goes like this:

If it is opened via H: then its links will be via H: and held in effect
as relative links.
If it is opened via J: then its links will be via J: and held in effect
as relative links.
If it is opened via a different drive letter the links will be via
whichever drive it was opened from whtn it was last saved, and they
will be in effect absolute links.

If the workbook is currently accessed via H or J it would be
interesting to move it elsewhere and see if the problem goes away.
You could always leave a shortcut to it where it used to be!

Otherwise I guess you could write a macro to remake the links when they
have gone wrong.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



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
Want Excel to break links between worksheets in same file eclectic_kx Excel Worksheet Functions 1 May 25th 05 06:38 PM
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 12:24 AM
How do I Break links Using Excel 2000 DaddyMan Excel Discussion (Misc queries) 1 December 9th 04 10:18 PM
can I query active directory with excel? jwolson Excel Discussion (Misc queries) 0 December 8th 04 03:53 PM
upgrade to excel 2003 update broken links error tigger Links and Linking in Excel 0 December 1st 04 06:39 PM


All times are GMT +1. The time now is 11:50 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017