Wait, what didn't work? You mean that after you copied the email addresses back to the original worksheet, they turned back into hyperlinks? (You gotta be specific, Tom.)

If that's what you meant, then maybe I should have explained that you can turn off Excel's eagerness to create hyperlinks in the Options. Let's see, here... Ah, here it is: File, Options, Proofing, AutoCorrect Options, go to the AutoFormat As You Type tab, uncheck "Internet and network paths with hyperlinks".

And remember, that link I pointed out said that the workbook might be protected or shared, if that's any help.