Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Cant unformat email address hyperlink in Excel the way HELP says I can

23 Jan 2014   #11
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Perhaps you could try this. Copy all those with the hyperlink active into a new workbook & change them to a normal cell. Then instead of copying them back to the previous workbook, copy the ones in the previous workbook to the new workbook.
Sounds stupid but it might work.


My System SpecsSystem Spec
.
24 Jan 2014   #12
tomseeley

Win 7 home premium 64 bit
 
 

Kari,

Hey thanks man! No problem! I really appreciate your help! But I think the issue has run its course, for at least 3 reasons: 1) It's not a big problem for me; it's only a curiosity, that I don't have to solve; and 2) I'm headed for Palm Springs, CA, for two weeks vacation! It's 19 deg here in SC right now, so this is something I'm really looking forward to! And I don't intend to take Excel issues along with me! and 3) I just tried what someone on another help forum suggested, and presto! I "copy/paste special-ed" and it works!
My System SpecsSystem Spec
24 Jan 2014   #13
tomseeley

Win 7 home premium 64 bit
 
 

Hey SlartyBart, Thx for helping! I just posted a reply above, saying someone else suggested another way to copy/paste, which seems to work. I appreciate your help too.

By the way. Your screen name sounds vaguely familiar. Any chance it comes from the Hitchhiker's Guide...?
My System SpecsSystem Spec
.

24 Jan 2014   #14
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Does "I designed the fjords, all those squiggly lines"
or
All the flower pot could think of was "Oh no, not again!"
or
Come along or you'll be late!
Late for what?
Late as in the Late Arthur Dent.

answer your question re: my forum name?

Gee Tom, I feel kind of bad for you, having to go to Palm Springs, maybe I'll head sown to SC for a warm up.

Cant unformat email address hyperlink in Excel the way HELP says I can-temps.png

Before you go, How did you originally put the data in Excel? and Is this something you do with any regularity?
You might want to poke around in Excel to see if there is a way to prevent future issues with hyperlinks.

Anyway, enjoy your 2 weeks in Sunny CA.

Bill


My System SpecsSystem Spec
31 Jan 2014   #15
bawldiggle

XP/7x32 & x64/8x64/8.1x64
 
 

Excel 2003 had a habit of occasional corrupt files

As a newbie to Excell 2010 while rewriting an addin, my tiny experimental .xlsm file corrupted.
Yep ... Excel can do it sometimes.
My System SpecsSystem Spec
31 Jan 2014   #16
whs
Microsoft MVP

Vista, Windows7, Mint Mate, Zorin, Windows 8
 
 

Did you first highlight the hyperling before you tried to remove it ?
My System SpecsSystem Spec
31 Jan 2014   #17
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Quote   Quote: Originally Posted by tomseeley View Post
Kari,

Hey thanks man! No problem! I really appreciate your help!
But I think the issue has run its course, for at least 3 reasons:
  1. It's not a big problem for me; it's only a curiosity, that I don't have to solve; and
  2. I'm headed for Palm Springs, CA, for two weeks vacation! It's 19 deg here in SC right now, so this is something I'm really looking forward to! And I don't intend to take Excel issues along with me! and
  3. I just tried what someone on another help forum suggested, and presto! I "copy/paste special-ed" and it works!
Thread Start is probably in Palm Springs by now. A workaround resolved the issue.
My System SpecsSystem Spec
06 Nov 2015   #18
jdat

Windows 7
 
 
I got it!

@TomSeeley - I was having exactly the same problem! Fixed it by: Un-sharing the workbook.

Let me know if this works for you, too!
My System SpecsSystem Spec
Reply

 Cant unformat email address hyperlink in Excel the way HELP says I can




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Chrome crashes when I try to open a hyperlink from My Email client
Ok, when I open my email client, whatever it may be I had an email from someone that had a HTTP link to a forum for me. When I click on this link, Google Chrome, my default browser tries to open the link, but all that happens is my extensions in Chrome all report crashing in the bottom right corner...
Browsers & Mail
Website email hyperlink trouble
Greets from Japan ...New computer with Windows 7 and latest IE version . When I click on a email contact hyperlink on websites I am not able to access automatically via Windows Live Mail which my old HP with the same 7 and IE has no problem with . A message pops up in Japanese , something about the...
Browsers & Mail
Use of hyperlink in email reply
Using Outlook V10, adding hyperlink to an original message works fine. When I do a reply, inserting a hyperlink sometimes works. And for some message replies, the formatting and hperlink icons are not available. Is there an explanation for this?
Browsers & Mail
Can I save an Outlook e-mail trail and hyperlink to it from Excel?
Hi guys I have an Excel spreadsheet that tracks document reviews. One form of evidence that a document has been reviewed is an e-mail from the reviewer (eg, "I've reviewed it and told John to make corrections as per the attached"). Aside from printing the mail to a pdf and saving it somewhere...
Microsoft Office
Unable send clickable hyperlink from IE9 using default email
I can send links going to : "Page" > " Send link by email", but they are set in plain text and cannot be clicked by the receivor of the email to bring up the desred page. :( If I copy and paste the link on a new Windows Live Mail message it works just fine - the link is clickable. :confused: ...
Browsers & Mail
Mozilla ignores profile when opened via email/web hyperlink
When I open Mozilla via local icons, it will read and load a specific profile. This allows me to use 3.6.13 (..\firefox.exe" -p "FF_3_6_13" -no-remote) and 4.0b9pre (..\firefox.exe" -p "Minefield64" -no-remote) without one interfering with the other. (4.0b9pre is set as default). When the...
Browsers & Mail


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:33.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App