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.