Hi All,

I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds
of links to forms to each individual row created. I last saved my file last
Thursday and today I opened my file only to find my Hyperlinks that were
associated to a G:\ Drive (network) have now showing my local D:\ as the
Hyperlink. No files are stored on my D:\. Also it is referring to a path
where no folder is on my d:\ drive.

Any suggestions as to why this would happen? If so any idea how to reftify
all the links back to G:\ without doing each one individually?
--
Jeff
Sydney, Australia

On Mon, 16 Nov 2009 22:13:02 -0800, Etz99
wrote:

Hi All,

I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds
of links to forms to each individual row created. I last saved my file last
Thursday and today I opened my file only to find my Hyperlinks that were
associated to a G:\ Drive (network) have now showing my local D:\ as the
Hyperlink. No files are stored on my D:\. Also it is referring to a path
where no folder is on my d:\ drive.

Any suggestions as to why this would happen? If so any idea how to reftify
all the links back to G:\ without doing each one individually?

Jeff,

I have seen similar behavior when the excel file is located on a
sharepoint. I have had some success in that environment by going to
the excel options, select the save item on the left nav bar and then
select "on web server" (I'm doing this from memory since I'm not
informt of my work ciomputer, but it is something very similar to what
I just described.) Of course your situation may be completely
different.

Oh, BTW, this happened often enough (this is a multi-user environment)
that I developed a simple macro to a do string replacement on every
hyperlink in the workbook to restore them to the correct value.







John Keith

Hey John,

I don't use sharepoint so I can't tell you anything about that.

If I wrote a macro to restore the locations correctly, then exactly where
would these locations be found seeing as they are no longer in the worksheet?

Sorry I am a little confused.


--
Jeff
Sydney, Australia


"John Keith" wrote:

On Mon, 16 Nov 2009 22:13:02 -0800, Etz99
wrote:

Hi All,

I have Microsoft Office 2007 and I have a spreadsheet that contains hundreds
of links to forms to each individual row created. I last saved my file last
Thursday and today I opened my file only to find my Hyperlinks that were
associated to a G:\ Drive (network) have now showing my local D:\ as the
Hyperlink. No files are stored on my D:\. Also it is referring to a path
where no folder is on my d:\ drive.

Any suggestions as to why this would happen? If so any idea how to reftify
all the links back to G:\ without doing each one individually?

Jeff,

I have seen similar behavior when the excel file is located on a
sharepoint. I have had some success in that environment by going to
the excel options, select the save item on the left nav bar and then
select "on web server" (I'm doing this from memory since I'm not
informt of my work ciomputer, but it is something very similar to what
I just described.) Of course your situation may be completely
different.

Oh, BTW, this happened often enough (this is a multi-user environment)
that I developed a simple macro to a do string replacement on every
hyperlink in the workbook to restore them to the correct value.







John Keith

.

On Wed, 18 Nov 2009 17:46:03 -0800, Etz99
wrote:

Hey John,

I don't use sharepoint so I can't tell you anything about that.

If I wrote a macro to restore the locations correctly, then exactly where
would these locations be found seeing as they are no longer in the worksheet?

Sorry I am a little confused.

Jeff,

I'm no expert but I'll share what I have observed.

I have seen broken links in my environment whee we use sharepoint but
I think maybe the conditions may exist in any siutation where you are
using a remote server (which I think you are since you referred to
some network drives.)

If you open Excel options then click on the Save menu item on the far
left there are several options. One of the options is:

Offline Editing options for document management server files

and for this there are two radio buttons:

The server drafts located on this computer
The Web Server

If the first option is selected this is the case when I have seen
links being modified. In this option when a file is ediitted a copy of
it is placed on your local computer and it appears to me that when
this is done the hyperlinks are all changed to some invalid path that
starts with a path to where this local copy of the file is located
(this path can be user defined so it varies per user.)

Only a portion of the path to the link is changed, here is a
fictitious example to illustrate:

The correct hyperlink path:

http://team1.sharepoint.bizmumble.co...ts/report1.xls

will get changed to:

C:\Users\username\folder\reports\report1.xls

I was able to do a search and replace on every hyperlink to restore
them back to the correct value.

search for "C:\Users\username\" and replace with

http://team1.sharepoint.bizmumble.com/

If the second option is selected I think that none of this
modification occurs.


John Keith