Help!

Excel 07 breaking links

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links RSS
Next:  Animating a background/wallpaper  
Author Message
LisaK
External


Since: Feb 17, 2009
Posts: 5



PostPosted: Tue Mar 17, 2009 4:37 pm    Post subject: Excel 07 breaking links
Archived from groups: microsoft>public>excel>links (more info?)

We have a document on a shared drive that we update often and hyperlink to
other documents. Currently, I created a link to a Word doc but when I email
it to a colleague, her link looks for the doc on her C drive. We've done
this many times with no problem. We have removed and retried creating the
link several times, have moved it to a higher level folder on the shared
drive, and have gone to the drive and found the doc, just to be sure it was
put in the right place. Does anyone know what this problem might be? Thank
you.
Back to top
Jeff Gordon
External


Since: Mar 17, 2009
Posts: 2



PostPosted: Tue Mar 17, 2009 9:10 pm    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"LisaK" wrote in message

> We have a document on a shared drive that we update often and hyperlink to
> other documents. Currently, I created a link to a Word doc but when I
> email
> it to a colleague, her link looks for the doc on her C drive. We've done
> this many times with no problem. We have removed and retried creating the
> link several times, have moved it to a higher level folder on the shared
> drive, and have gone to the drive and found the doc, just to be sure it
> was
> put in the right place. Does anyone know what this problem might be?
> Thank
> you.
>
You have to save it somewhere on hard-drive and reopen it. If you open
attachments from email, then the link does not work. Otherwise, if you have
sent just a hyperlink like - file://C:\\Shared folder\Shared document.doc -
then it open that from local drive. I prefer this version - \\server\shared
folder\Shared document.doc -.

Anyway, any of those does not open anything, if you have made link to a Word
document and you have opened that as attachment from mail. Hope this give
an advice?

JG
Back to top
LisaK
External


Since: Feb 17, 2009
Posts: 5



PostPosted: Wed Mar 18, 2009 9:45 am    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm not sure I agree with this. We've been using links in this way for
years, and it has worked. The document is being opened by people within the
group, not being sent outside the company or anything like that. Maybe I'm
missing something, as I don't find this answer to be clear.

"Jeff Gordon" wrote:

>
> "LisaK" wrote in message
>
> > We have a document on a shared drive that we update often and hyperlink to
> > other documents. Currently, I created a link to a Word doc but when I
> > email
> > it to a colleague, her link looks for the doc on her C drive. We've done
> > this many times with no problem. We have removed and retried creating the
> > link several times, have moved it to a higher level folder on the shared
> > drive, and have gone to the drive and found the doc, just to be sure it
> > was
> > put in the right place. Does anyone know what this problem might be?
> > Thank
> > you.
> >
> You have to save it somewhere on hard-drive and reopen it. If you open
> attachments from email, then the link does not work. Otherwise, if you have
> sent just a hyperlink like - file://C:\\Shared folder\Shared document.doc -
> then it open that from local drive. I prefer this version - \\server\shared
> folder\Shared document.doc -.
>
> Anyway, any of those does not open anything, if you have made link to a Word
> document and you have opened that as attachment from mail. Hope this give
> an advice?
>
> JG
>
>
>
Back to top
Jeff Gordon
External


Since: Mar 17, 2009
Posts: 2



PostPosted: Wed Mar 18, 2009 3:10 pm    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi!

Let me know, how the link look like.

JG
"LisaK" wrote in message

> I'm not sure I agree with this. We've been using links in this way for
> years, and it has worked. The document is being opened by people within
> the
> group, not being sent outside the company or anything like that. Maybe
> I'm
> missing something, as I don't find this answer to be clear.
>
> "Jeff Gordon" wrote:
>
>>
Back to top
jaf
External


Since: Sep 30, 2003
Posts: 56



PostPosted: Tue Mar 24, 2009 12:32 am    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Lisa,
I saw your other post as well.
The forward slash "/" is UNC convention.
The backslash "" is windows path convention.
See http://en.wikipedia.org/wiki/Path_(computing)

I would say Excel is confused as to what the link should be if your seeing both slashes.

C:\ will assumed to be a drive on the local machine, unless your company has mapped "C:" as a network drive you will run into
problems.

You mentioned hyperlinks. Are the hyperlinks or Excel links?

Stick with //server/share to avoid problems. You never know when a drive is going to get remapped.

John



"LisaK" wrote in message
> I'm not sure I agree with this. We've been using links in this way for
> years, and it has worked. The document is being opened by people within the
> group, not being sent outside the company or anything like that. Maybe I'm
> missing something, as I don't find this answer to be clear.
>
> "Jeff Gordon" wrote:
>
>>
>> "LisaK" wrote in message
>>
>> > We have a document on a shared drive that we update often and hyperlink to
>> > other documents. Currently, I created a link to a Word doc but when I
>> > email
>> > it to a colleague, her link looks for the doc on her C drive. We've done
>> > this many times with no problem. We have removed and retried creating the
>> > link several times, have moved it to a higher level folder on the shared
>> > drive, and have gone to the drive and found the doc, just to be sure it
>> > was
>> > put in the right place. Does anyone know what this problem might be?
>> > Thank
>> > you.
>> >
>> You have to save it somewhere on hard-drive and reopen it. If you open
>> attachments from email, then the link does not work. Otherwise, if you have
>> sent just a hyperlink like - file://C:\\Shared folder\Shared document.doc -
>> then it open that from local drive. I prefer this version - \\server\shared
>> folder\Shared document.doc -.
>>
>> Anyway, any of those does not open anything, if you have made link to a Word
>> document and you have opened that as attachment from mail. Hope this give
>> an advice?
>>
>> JG
>>
>>
>>
Back to top
theGman
External


Since: Jun 09, 2009
Posts: 1



PostPosted: Tue Jun 09, 2009 7:06 pm    Post subject: RE: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

LisaK, we have this same issue in our Excel 2007 files sometimes. I am
really curious if you have solved it.

We have hyperlinks to files on our internal LAN SharePoint servers. The
hyperlinks work fine for me and others. But every so often someone opens the
Excel file and resaves it (without deliberately editting any of the
hyperlinks) and suddenly all of the hyperlinks no longer point to the server
location but instead to that person's C:\ drive (which of course is wrong, so
the link is broken now forever). Re-fixed the hyperlink just starts the
process all over again, the links always break/re-point to the wrong
location.

Folks are not saving the file to their C: drive at all. It is very
strange, and I would like someone from Microsoft (or others who can) to
explain why Excel would change the "absolute" (not "relative") file path
designated in the Hyperlink in Excel 2007.
Back to top
kangdang
External


Since: Aug 18, 2009
Posts: 1



PostPosted: Tue Aug 18, 2009 6:41 pm    Post subject: RE: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Gman,

I am having this same problem exactly and have yet to find a solution. Even
after fixing the links to point back to their original location, they
eventually go back to pointing to the user's C:\ drive. As with your issue
both users are using Office 2007, so there isn't any compatability issues.
Anyone who could resolve or assist in this problem would be greatly
appreciated.

Thanks

"theGman" wrote:

> LisaK, we have this same issue in our Excel 2007 files sometimes. I am
> really curious if you have solved it.
>
> We have hyperlinks to files on our internal LAN SharePoint servers. The
> hyperlinks work fine for me and others. But every so often someone opens the
> Excel file and resaves it (without deliberately editting any of the
> hyperlinks) and suddenly all of the hyperlinks no longer point to the server
> location but instead to that person's C:\ drive (which of course is wrong, so
> the link is broken now forever). Re-fixed the hyperlink just starts the
> process all over again, the links always break/re-point to the wrong
> location.
>
> Folks are not saving the file to their C: drive at all. It is very
> strange, and I would like someone from Microsoft (or others who can) to
> explain why Excel would change the "absolute" (not "relative") file path
> designated in the Hyperlink in Excel 2007.
Back to top
Metoo
External


Since: Sep 01, 2009
Posts: 1



PostPosted: Tue Sep 01, 2009 6:11 pm    Post subject: RE: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Gman,
Yup, I have the exact same problem, but mine happens in Word too. We have
coworkers collaborating on a document, but when I go to do the final review,
all sharepoint hyperlinks (Intranet) are converted to C drive links and are
unusable.

I am going to play with some document library settings. I seem to remember
a setting that allows checked-out documents to be stored on the local drive
until they are checked back in. I wonder if that is causing the
problem....For me, it is very frustrating because some documents have
literally a hundred hyperlinks to internal forms and info.

Funny, the internet (external) links don't get changed at all.
Back to top
Gary1972
External


Since: Sep 10, 2009
Posts: 1



PostPosted: Thu Sep 10, 2009 1:28 pm    Post subject: RE: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just to add another me too:

Hyperlinks like http://mycompany.com/folder/this.xls in an excel spreadsheet
are getting converted to file:///c:\my documents\folder\this.xls.

It seems to be when saving the excel file into a Sharepoint 2007 document
library.

"Metoo" wrote:

> Gman,
> Yup, I have the exact same problem, but mine happens in Word too. We have
> coworkers collaborating on a document, but when I go to do the final review,
> all sharepoint hyperlinks (Intranet) are converted to C drive links and are
> unusable.
>
> I am going to play with some document library settings. I seem to remember
> a setting that allows checked-out documents to be stored on the local drive
> until they are checked back in. I wonder if that is causing the
> problem....For me, it is very frustrating because some documents have
> literally a hundred hyperlinks to internal forms and info.
>
> Funny, the internet (external) links don't get changed at all.
>
>
Back to top
Bill Manville
External


Since: Jul 30, 2004
Posts: 542



PostPosted: Thu Oct 22, 2009 4:10 pm    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

If the links were originally to files in the same folder as the
spreadsheet (or possibly sub-folders thereof) then Excel will hold them
as relative links by default. So, when the spreadsheet gets moved
somewhere else the links will be interpreted as relative to that new
folder and the files may well not reside there.

I recommend trying the following (2003 or earlier):
File > Properties > Summary > Hyperlink Base:
\\SomeNonServer\SomeNonFolder

In Excel 2007 you get there by [that's progress for you!]:
Office Button > Prepare > Properties > Document Properties > Advanced
Properties > Summary

This will force Excel to hold hyperlinks as absolute rather than
relative to its assumed base (the folder it came from). Then remake
any links which are not pointing to the right place.

If you try this, please post back here with the results so that others
can tell whether the advice is worth following or not.

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


Since: Jan 05, 2010
Posts: 1



PostPosted: Tue Jan 05, 2010 10:59 pm    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

I tried following these steps below and still had the same problem. When I
email the file, its converting the file path from +\\miscserver\miscfolder to
this:

=+'C:\Documents and Settings\jlastname\Local Settings\Temporary Internet
Files\Content.Outlook\

Could it be an issue with Outlook or using Excel 2007?

We don't remember having this issue before and all of my co-workers have the
same permissions and access rights.

Thank you,

Jazmin

"Bill Manville" wrote:

> If the links were originally to files in the same folder as the
> spreadsheet (or possibly sub-folders thereof) then Excel will hold them
> as relative links by default. So, when the spreadsheet gets moved
> somewhere else the links will be interpreted as relative to that new
> folder and the files may well not reside there.
>
> I recommend trying the following (2003 or earlier):
> File > Properties > Summary > Hyperlink Base:
> \\SomeNonServer\SomeNonFolder
>
> In Excel 2007 you get there by [that's progress for you!]:
> Office Button > Prepare > Properties > Document Properties > Advanced
> Properties > Summary
>
> This will force Excel to hold hyperlinks as absolute rather than
> relative to its assumed base (the folder it came from). Then remake
> any links which are not pointing to the right place.
>
> If you try this, please post back here with the results so that others
> can tell whether the advice is worth following or not.
>
> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - respond to newsgroup
>
> .
>
Back to top
Bill Manville
External


Since: Jul 30, 2004
Posts: 542



PostPosted: Wed Jan 06, 2010 8:10 pm    Post subject: Re: Excel 07 breaking links [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The solution I proposed was specifically for hyperlinks.
It won't have any effect on Excel (formula) links such as those you
describe.

Formula links are held as relative if the source workbook is in the
same folder as the destination workbook, or a sub-folder of it. [Which
is good if different users use different drive mappings or if the files
are moved as a set to a different location, but bad in your case of
emailing the file]

For formula links, I suggest you do the following:
- in Excel, open the file from its network location
- save it to a local folder. That will make the links non-relative
- send the local version by email.

Of course, the recipient will likely be unable to access the source
files. (Because if he could then you could just send him a link to the
file instead of the whole file)

Please let us know how you get on with this approach.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Links All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum