Forum Discussion
hyperlink not showing correctly
I used a program to generate hyperlinks in Excel using =HYPERLINK("location", "text to show"). Strangely when opened in Excel, they all show as the full code of text instead of the "text to show" with a link to the location. I remember it worked perfectly in the previous version of Excel (maybe 2010).
It will work properly after I click on the table cell, but there are so many cells.
Is there a quick fix for this?
Thanks,
4 Replies
- I found an indirect solution. I can copy the whole column and paste it to notepad. Save it as unicode text. Rename the extension to csv. Open it with Excel, and everything looks and links right. It's workable but requires extra steps.
BTW, the data contains non-West letters. I have to import from Data > From Text/CSV to show the text correctly. I don't know if it is related, but it worked without extra step in Excel 2010 which I don't have now.
Thanks!- That happens every now and then if the workbook is generated from a non-Office app. Good workaround!
- Possibly 'Show Formulas' is enabled or the cells are formatted as Text so the formulas won't evaluate.
Patrick2788 Thanks for the suggestion. I just tried turning "Show Formulas" on and off. I could see all the corrected ones showing hyperlink formula when it's on and back to text with link after turning off, but it does not affect other cells that I've not clicked on to correct them.
