Error: "The address of this site is not valid.." but I have SP2.

[Rutabaga]

Hello Helpful Ones (you all are awesome):

When I click a hyperlink I've created (from an Excel cell to a Word doc), I
get the "The address of this site is not valid. Check the address and try
again." My situation meets the criteria addressed in an earlier 'hotfix',
which was incorporated into SP2. Those criteria are:

1. The document that contains the hyperlink was saved in an Office 2003
program.
2. The document that contains the hyperlink and the document that the
hyperlink opens are located on the same network server.
3. The document that contains the hyperlink and the document that the
hyperlink opens are located in separate shares on the network server.
4. The hyperlink contains a relative URL.

I have SP2, which was supposed to resolve this error. When I save the Excel
doc to my desktop, then create the link, it works nicely; but when the above
criteria exist, no go.

 

[Rutabaga]

BUMP

Sorry to bump, but I'm having a tough time trying to work around this error.
I can manually type in the file path (as opposed to the annoying ../../../)
and get the links to work, but upon saving, they revert back. Yes, I can
turn off 'Update Links on Save' (or whatever it is), but it's a public doc to
which people post updated data, so if their system isn't set up with the
Update Links off, it screws things all up again.

Any thots? Thanks

 

[JoAnn Paules]

Bumping doesn't work here.

--

JoAnn Paules
Microsoft MVP - Publisher

How to ask a question
http://support.microsoft.com/kb/555375

 

[Bob I]

Put this Macro in the file, end of problem.

Sub Autpen()
'
' Autpen Macro
'
'
Application.DefaultWebOptions.UpdateLinksOnSave = False

End Sub

 

[Rutabaga]

Very Nice. TYVM

Put this Macro in the file, end of problem.

Sub Autpen()
'
' Autpen Macro
'
'
Application.DefaultWebOptions.UpdateLinksOnSave = False

End Sub

 

[Bob I]

You're welcome, have a good day!

Very Nice. TYVM

: