PC Review


Reply
Thread Tools Rate Thread

Damaged Hyperlink in Excel 2003 after saving an Excel Sheet

 
 
Andy
Guest
Posts: n/a
 
      9th Jun 2004
Hello,
I've got a problem with hyperlinks in Excel 2003.
Until I save the document they work fine - after saving a view
of the hyperlinks are corrupted.
There is a connection between the server which is named in the
hyperlink and the setting under options-general called "standard
save place" in german.

I've got a mounted drive H which is located on \\filer\user\andy
(Server is Windows 2000) and the entry H:\ on the option-general-tab.
H:\ is connected with AD for the user (profil-"basic-folder")

There's a further drive on this Fileserver for general using.
It's mounted as Drive O and located on \\filer\transfer.
Transfer and User are shares on this server.

If I create a link in Excel to a file on drive H - everything works
fine
- after saving, too!
If the link is to a file on drive O, it works fine first, until i save
the document. After saving there is an error-message displayed:
German "Die Adresse dieser Website ist unzulässig. Überprüfen Sie die
Adresse und versuchen Sie es erneut."
I try to translate:
"The address to this website is illegal. Check the address und try
again".

Now, there is no preview on mouse over on this link.
"Edit hyperlink" opens a window with the suggestion:
before save: \\filer\transfer\allgem\test.txt (on mouse-over there is
a prefix
"file:///")
after save: ..\..\..\transfer\allgem\test.txt

Changing the setting options-general "standard save place" to c:\ and
this links work
fine ... but I need this setting on drive H:\

Now this link is corrupted.

Has there anyone an idea ...

Thanks + Bye
Andy
 
Reply With Quote
 
 
 
 
Tonio
Guest
Posts: n/a
 
      1st Jul 2004
Hello,

I have the same problem with Excel 2002 (XP) under win2k and I have no
response.

Bye,
Tonio

"Andy" <(E-Mail Removed)> a écrit dans le message de
news:(E-Mail Removed)...
> Hello,
> I've got a problem with hyperlinks in Excel 2003.
> Until I save the document they work fine - after saving a view
> of the hyperlinks are corrupted.
> There is a connection between the server which is named in the
> hyperlink and the setting under options-general called "standard
> save place" in german.
>
> I've got a mounted drive H which is located on \\filer\user\andy
> (Server is Windows 2000) and the entry H:\ on the option-general-tab.
> H:\ is connected with AD for the user (profil-"basic-folder")
>
> There's a further drive on this Fileserver for general using.
> It's mounted as Drive O and located on \\filer\transfer.
> Transfer and User are shares on this server.
>
> If I create a link in Excel to a file on drive H - everything works
> fine
> - after saving, too!
> If the link is to a file on drive O, it works fine first, until i save
> the document. After saving there is an error-message displayed:
> German "Die Adresse dieser Website ist unzulässig. Überprüfen Sie die
> Adresse und versuchen Sie es erneut."
> I try to translate:
> "The address to this website is illegal. Check the address und try
> again".
>
> Now, there is no preview on mouse over on this link.
> "Edit hyperlink" opens a window with the suggestion:
> before save: \\filer\transfer\allgem\test.txt (on mouse-over there is
> a prefix
> "file:///")
> after save: ..\..\..\transfer\allgem\test.txt
>
> Changing the setting options-general "standard save place" to c:\ and
> this links work
> fine ... but I need this setting on drive H:\
>
> Now this link is corrupted.
>
> Has there anyone an idea ...
>
> Thanks + Bye
> Andy



 
Reply With Quote
 
 
 
 
Heather
Guest
Posts: n/a
 
      26th Jul 2004
"Tonio" <(E-Mail Removed)> wrote in message news:<#(E-Mail Removed)>...
> Hello,
>
> I have the same problem with Excel 2002 (XP) under win2k and I have no
> response.
>
> Bye,
> Tonio
>
> "Andy" <(E-Mail Removed)> a écrit dans le message de
> news:(E-Mail Removed)...
> > Hello,
> > I've got a problem with hyperlinks in Excel 2003.
> > Until I save the document they work fine - after saving a view
> > of the hyperlinks are corrupted.
> > There is a connection between the server which is named in the
> > hyperlink and the setting under options-general called "standard
> > save place" in german.
> >
> > I've got a mounted drive H which is located on \\filer\user\andy
> > (Server is Windows 2000) and the entry H:\ on the option-general-tab.
> > H:\ is connected with AD for the user (profil-"basic-folder")
> >
> > There's a further drive on this Fileserver for general using.
> > It's mounted as Drive O and located on \\filer\transfer.
> > Transfer and User are shares on this server.
> >
> > If I create a link in Excel to a file on drive H - everything works
> > fine
> > - after saving, too!
> > If the link is to a file on drive O, it works fine first, until i save
> > the document. After saving there is an error-message displayed:
> > German "Die Adresse dieser Website ist unzulässig. Überprüfen Sie die
> > Adresse und versuchen Sie es erneut."
> > I try to translate:
> > "The address to this website is illegal. Check the address und try
> > again".
> >
> > Now, there is no preview on mouse over on this link.
> > "Edit hyperlink" opens a window with the suggestion:
> > before save: \\filer\transfer\allgem\test.txt (on mouse-over there is
> > a prefix
> > "file:///")
> > after save: ..\..\..\transfer\allgem\test.txt
> >
> > Changing the setting options-general "standard save place" to c:\ and
> > this links work
> > fine ... but I need this setting on drive H:\
> >
> > Now this link is corrupted.
> >
> > Has there anyone an idea ...
> >
> > Thanks + Bye
> > Andy


If the folder or file name contains spaces, you need to enclose the
link within quotes (").

eg "\\servername\Folder\Sub Folder\File Name.doc"
 
Reply With Quote
 
felad
Guest
Posts: n/a
 
      20th Dec 2004
Hi

Do you have a solution to the save problem ?
( It has nothing to do with blanks in folder name )

Elad

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to Same sheet but after that want to hide link sheet Ash Baw Microsoft Excel Programming 1 10th Apr 2013 09:16 AM
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 mistewalker Microsoft Excel Worksheet Functions 5 7th Jan 2008 12:36 AM
after using 2003, 2000 says This view is damaged =?Utf-8?B?Qm9iIEZpbmRsYXk=?= Microsoft Outlook Interoperability 1 19th Mar 2005 01:41 AM
Excel workbook and sheet damaged Lalit H Kokku Microsoft Excel Misc 1 28th Jun 2004 02:44 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B Hannes Heckner Microsoft Excel Programming 1 5th Mar 2004 10:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 AM.