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
Disable the cancel option while saving the excel sheet-Excel 2007 Heera Microsoft Excel Programming 0 13th Jul 2010 10:10 AM
excel 2007 crash when saving a specific file as excel 2003 format Frustrated Microsoft Excel Crashes 0 18th Jul 2008 12:44 PM
Excel 2007 crashed after saving excel 2003 file into 2003 format kpy Microsoft Excel Crashes 0 17th Jun 2008 08:53 AM
Excel 2003 says file is damaged & Can't open, Opens in Excel 2000 =?Utf-8?B?TWlzc0s=?= Microsoft Excel Crashes 0 15th Mar 2006 01:46 AM
Excel workbook and sheet damaged Lalit H Kokku Microsoft Excel Misc 1 28th Jun 2004 02:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:37 PM.