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.:)
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!
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...?
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.
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
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.
@TomSeeley - I was having exactly the same problem! Fixed it by: Un-sharing the workbook.
Let me know if this works for you, too!
Quote
