B
Brettjg
This is not an Excel question, but is related to it. I know for certain that
the formula that I am using is correct, because it has always worked.
This formula STILL works:
=HYPERLINK("C:\0. QUO VADIS\","0. QUO VADIS")
This formula does not work now:
=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P","Dunn, P") but it always has
It comes up with an error msg that the path "P" does not exist or is not a
directory. This has nothing to do with the comma in the folder name because
they have always been there. I can still open the folders by drilling down
from the top, so there's nothing wrong with them. For some reason Windows
seems to be truncating the path to the last one or two characters, and of
course can't find it. But this does not explain why the hyperlink to open QUO
VADIS still works.
One question is: how do I delete a folder opening/explore action? When I
look at the "Explore" option that I created last night the "delete" is greyed
out, and nor can I modify it.
This came about because of the other problem that I'm having: when these
hypelinks do work (in a previous life) the folders open up subfolders in
separate windows, even though I have "same window" checked in folder options.
I noticed that if I used "Explore" instead of "open" then the same window was
used. So then I set a new default action of Explore
"C:\Windows\explorer.exe". I think I may have inadvertantly put the quote
marks in as well, but I can't remove the action now (or edit it). I notice in
the "Open" action that there is a checkbox for "Browse in same Window" but it
can't be checked. I think that would solve my separate windows problem, but
that is secondary to not being able to open them at all via = HYPERLINK
I've restored the previous version of the workbook, but it does the same. I
have proved that it's not the hyperlink formula, but don't know what to try
next.
Thanks for any help offered. Brett
the formula that I am using is correct, because it has always worked.
This formula STILL works:
=HYPERLINK("C:\0. QUO VADIS\","0. QUO VADIS")
This formula does not work now:
=HYPERLINK("C:\2. SETTLED CLIENTS\Dunn, P","Dunn, P") but it always has
It comes up with an error msg that the path "P" does not exist or is not a
directory. This has nothing to do with the comma in the folder name because
they have always been there. I can still open the folders by drilling down
from the top, so there's nothing wrong with them. For some reason Windows
seems to be truncating the path to the last one or two characters, and of
course can't find it. But this does not explain why the hyperlink to open QUO
VADIS still works.
One question is: how do I delete a folder opening/explore action? When I
look at the "Explore" option that I created last night the "delete" is greyed
out, and nor can I modify it.
This came about because of the other problem that I'm having: when these
hypelinks do work (in a previous life) the folders open up subfolders in
separate windows, even though I have "same window" checked in folder options.
I noticed that if I used "Explore" instead of "open" then the same window was
used. So then I set a new default action of Explore
"C:\Windows\explorer.exe". I think I may have inadvertantly put the quote
marks in as well, but I can't remove the action now (or edit it). I notice in
the "Open" action that there is a checkbox for "Browse in same Window" but it
can't be checked. I think that would solve my separate windows problem, but
that is secondary to not being able to open them at all via = HYPERLINK
I've restored the previous version of the workbook, but it does the same. I
have proved that it's not the hyperlink formula, but don't know what to try
next.
Thanks for any help offered. Brett