Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

Thanks Jacob for the response. I read most of the threads pertaining to the
hyperlink on this group. I found similar problems but not answered! Here is
the one back from 2006.....

Question
Subject: Hyperlink Problem 11/2/2006 5:45 AM PST

By: Globe Director In: microsoft.public.excel.worksheet.functions


From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?
....................
I forgot to mention that I am using Office 2003. As I mentioned earlier I
have no problem with the hyperlink when I define/link them to a cell. Problem
comes only when I close the file and reopen it, the hyperlink references
change. To workaround, I have to save the file as webpage. Then all the links
in the Excel starts working fine.

Once again thanks in anticipation.

KLJ

"Jacob Skaria" wrote:

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

I dont think you have tried this.; have you? This is a formula. does that
change?

=HYPERKLINK("c:\temp\")

'OR to a file
=HYPERLINK("file:////c:\book11.txt","book11.txt")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Thanks Jacob for the response. I read most of the threads pertaining to the
hyperlink on this group. I found similar problems but not answered! Here is
the one back from 2006.....

Question
Subject: Hyperlink Problem 11/2/2006 5:45 AM PST

By: Globe Director In: microsoft.public.excel.worksheet.functions


From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?
...................
I forgot to mention that I am using Office 2003. As I mentioned earlier I
have no problem with the hyperlink when I define/link them to a cell. Problem
comes only when I close the file and reopen it, the hyperlink references
change. To workaround, I have to save the file as webpage. Then all the links
in the Excel starts working fine.

Once again thanks in anticipation.

KLJ

"Jacob Skaria" wrote:

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

I tried the formula you mentioned. It does not work for the destination on
the network. Here is the location of the folder which I am trying to access
using the hyperlink. The 'friendly name' is 2118. I tried the formula with "
" and without. It gives the same result.

=HYPERLINK("\\tfile\Partitions\2\Projects\2118 Yellowhead TD", 2118)

I noticed that when I save the Excel file as webpage the hyperlink address
changes from ,
.../../../Partitions/2/Projects/2118%20Yellowhead%20TD

to,
\\tfile\Partitions\2\Projects\2118 Yellowhead TD

Thanks for your help and hope to find solution to the problem.

Regards,

"Jacob Skaria" wrote:

I dont think you have tried this.; have you? This is a formula. does that
change?

=HYPERKLINK("c:\temp\")

'OR to a file
=HYPERLINK("file:////c:\book11.txt","book11.txt")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Thanks Jacob for the response. I read most of the threads pertaining to the
hyperlink on this group. I found similar problems but not answered! Here is
the one back from 2006.....

Question
Subject: Hyperlink Problem 11/2/2006 5:45 AM PST

By: Globe Director In: microsoft.public.excel.worksheet.functions


From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?
...................
I forgot to mention that I am using Office 2003. As I mentioned earlier I
have no problem with the hyperlink when I define/link them to a cell. Problem
comes only when I close the file and reopen it, the hyperlink references
change. To workaround, I have to save the file as webpage. Then all the links
in the Excel starts working fine.

Once again thanks in anticipation.

KLJ

"Jacob Skaria" wrote:

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,

\\tfile\Partitions\2\Projects\2118 Yellowhead TD

Copy the above path and paste that to windows explorer 'Address Bar'. Do you
get that folder opened....If you can then the below should work..

=Hyperlink("\\tfile\Partitions\2\Projects\2118 Yellowhead TD","2118")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

I tried the formula you mentioned. It does not work for the destination on
the network. Here is the location of the folder which I am trying to access
using the hyperlink. The 'friendly name' is 2118. I tried the formula with "
" and without. It gives the same result.

=HYPERLINK("\\tfile\Partitions\2\Projects\2118 Yellowhead TD", 2118)

I noticed that when I save the Excel file as webpage the hyperlink address
changes from ,
../../../Partitions/2/Projects/2118%20Yellowhead%20TD

to,
\\tfile\Partitions\2\Projects\2118 Yellowhead TD

Thanks for your help and hope to find solution to the problem.

Regards,

"Jacob Skaria" wrote:

I dont think you have tried this.; have you? This is a formula. does that
change?

=HYPERKLINK("c:\temp\")

'OR to a file
=HYPERLINK("file:////c:\book11.txt","book11.txt")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Thanks Jacob for the response. I read most of the threads pertaining to the
hyperlink on this group. I found similar problems but not answered! Here is
the one back from 2006.....

Question
Subject: Hyperlink Problem 11/2/2006 5:45 AM PST

By: Globe Director In: microsoft.public.excel.worksheet.functions


From a worksheet (Excel Office 2003) on my computer I create a hyperlink to a
Word file on our server. All works fine until I save the worksheet, which
changes the hyperlink address, so it no longer functions. The changes are;
it removes the drive letter and adds %20 in front of each word in the
address. Can you help?
...................
I forgot to mention that I am using Office 2003. As I mentioned earlier I
have no problem with the hyperlink when I define/link them to a cell. Problem
comes only when I close the file and reopen it, the hyperlink references
change. To workaround, I have to save the file as webpage. Then all the links
in the Excel starts working fine.

Once again thanks in anticipation.

KLJ

"Jacob Skaria" wrote:

Check out help on worksheet function.

=HYPERKLINK("c:\temp\")

If this post helps click Yes
---------------
Jacob Skaria


"klj" wrote:

Objective:
I am craeting a list of folders with titles (names), like index, using
Excel. The objective is, when a user clicks on the folder name, the link
should open the folder. All folders are on different drives / locations on
the network.

Procedures:
I have created the list and hyperlink to each folder location. The list
works fine until I close the file and reopen it.

Problem:
When I reopen the file, folders on the same drive, where the excel files is
saved, would open and all other links would be disabled. When I save the file
as webpage and go back to the Excel file everything is working fine. In other
words everytime I open the Excel file, I have to save it as webpage before I
can use the file!

Is there any alternative procedure to create such a list?

Thanks,