Hyperlink Display problem
 

:confused: I had a bunch of hyperlinks set up linked to different
worksheets within the same workbook. Everything has been working fine
for months, but today I hit what I think was Ctrl plus an unknown key.
And now the hyperlinks only display the full formula, not just th text
I want. The hyperlinks still work though. I can not figure out what I
did. Any help would be great. Here is an example of the formula:

=HYPERLINK("[Groups.xls]k!a1", K!C8)
and
=K!B13


--
Panama Red
------------------------------------------------------------------------
Panama Red's Profile: http://www.excelforum.com/member.php...o&userid=26052
View this thread: http://www.excelforum.com/showthread...hreadid=393951

try:

tools|options|View tab
uncheck Formulas

I bet you hit ctrl-~ (ctrl-tilde). It's the shortcut key for viewing formulas.

Panama Red wrote:

:confused: I had a bunch of hyperlinks set up linked to different
worksheets within the same workbook. Everything has been working fine
for months, but today I hit what I think was Ctrl plus an unknown key.
And now the hyperlinks only display the full formula, not just th text
I want. The hyperlinks still work though. I can not figure out what I
did. Any help would be great. Here is an example of the formula:

=HYPERLINK("[Groups.xls]k!a1", K!C8)
and
=K!B13

--
Panama Red
------------------------------------------------------------------------
Panama Red's Profile: http://www.excelforum.com/member.php...o&userid=26052
View this thread: http://www.excelforum.com/showthread...hreadid=393951

--

Dave Peterson

Ctrl+~ did it. Easy fix to a silly problem. Thank you dave.


--
Panama Red
------------------------------------------------------------------------
Panama Red's Profile: http://www.excelforum.com/member.php...o&userid=26052
View this thread: http://www.excelforum.com/showthread...hreadid=393951