Hyperlinks disappeared in Microsoft Excel spreadsheet

1153205 pts.
Tags:
Microsoft Excel
I have this large Microsoft Excel spreadsheet and one specific column has a list of our website (and each our hyperlinked). Our company lost power during a storm and now when I open the spreadsheet, the hyperlinks are gone (just the text appears). Why did this happen? There's way too many to add again. What should I do?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
If you lost power while the spreadsheet was open you may have a .BAK version to do a recovery from.  
Else you can try this (sub A1 for your cell reference)
  1. Create a formula in an empty cell, ="=hyperlink(""" & A1 & """)"
  2. Drag down for length of all cells
  3. Copy the data in the new formula column
  4. Paste “Special Values-only”   over the original hyperlink column
  5. Highlight column, click CtrlH (to replace), finding and replacing = with = (somehow forces re-evaluation of cells).
  6. Cells should now be clickable as hyperlinks. If you want the blue/underline style, then just highlight all cells and choose the Hyperlink style.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    First check the paths of the hyperlinks that you linked when created hyperlinks. Are the hyperlinks internal/external? If they are external link, check the files that you mentioned erstwhile that the files are intact and not damaged/corrupted. If the links are internal try to run repair option and see if that helps. This is a built-in tool of MS Office. Open the excel file. Click the office button and click open > browse & then select the excel file. Now click drop down menu & select open to repair. If the case of for only file/spreadsheet, you can recreate the same.
    141,290 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: