View Single Post
 
Old 01-23-2014, 07:06 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Gee, I was thinking—maybe I'm still thinking—that now that you have automatic hyperlinks turned off, you can do what you did before: copy that whole column of email address to another workbook, "break" the hyperlinks (if you still need to) and then copy them back. With that option turned off, I was thinking you'd get plain text even in the original shared workbook.

Of course, it may be easier to make it "not shared", remove the hyperlinks and then share it again. Problem is, I don't really know what's meant by "shared". Is it in a Sharepoint directory? Probably not that. Is there a flag somewhere? Does it simply mean that some other user has it open at the same time? I'm not sure.

I don't mind answering more questions, but I have no more ideas to offer just now until you hand me some.
Reply With Quote