- However my links still won't export. I've tried the Excel Worksheet as well as the Excel 97-2003 options and neither works. It exports fine to PDF and Word but just not Excel. I am setting the hyperlink via the value field for an HTML text box. I've also tried setting the Navigate To Url property and that doesn't work either.
- You can download the Microsoft Easy Fix 50388.msi tool from the link of google drive as mentioned below:- https://drive.google.com/file/d/1SCa7RU7bRZssBf-ba.
Oct 20, 2012 HYPERLINK function is not working in my any excel book whichever i'm creating now.but the HYPERLINK function is working fine in my old excel book which was prepared so many months before.what is the problem?there is no problem with the syntax of the HYPERLINK which i entered but still the function is not working. Hyperlink not working in excel My college has put together a matrix with several hundred hyperlinks to certificates stored on his machine, he has then emailed this matrix to our team, however the hyperlinks only work on his machine.
How to prevent/disable automatic hyperlinks in Excel?
As we all known, Excel create clickable hyperlinks automatically when we input the web addresses into cells. Maybe, sometimes, this is somewhat annoying. Today, I will introduce some quick tricks for you to prevent automatic hyperlinks in Excel.
Convert plaint text to hyperlink with Kutools for Excel
Prevent automatic hyperlinks with Autocorrect Options in Excel
The build-in Autocorrect Options in Excel can help you to disable the automatic hyperlinks when you enter the web address. Do as this:
1. In Excel 2010/2013, click File > Options and in Excel 2007, click Office button > Excel Options to open the Excel Options dialog.
2. In the Excel Options dialog box, click Proofing from the left pane, and click AutoCorrect Options in the right section. See screenshot:
3. And then in the AutoCorrect dialog, click AutoFormat As You Type tab, and uncheck Internet and network paths with hyperlinks option under Replace as you type section, see screenshot:
4. After finishing the settings, click OK > OK to close the dialogs.
5. And now when you enter your web address into a cell, the internet address will not become clickable hyperlink. See screenshot:
Note: After disabling this feature, all the web addresses in the worksheet will not be converted to the clickable hyperlinks any more.
Prevent automatic hyperlinks with shortcut keys in Excel
But sometimes, you need to leave the hyperlink feature on and just need to prevent some specific hyperlinks, you can use the following shortcut keys to undo the hyperlink immediately after it's created.
1. Type your web address and press Enter key.
2. Then press Ctrl+Z immediately. And the clickable hyperlink has been converted to the plain text.
Convert plaint text to hyperlink with Kutools for Excel
In sometimes, you have a list of texts which want to convert to linkable hyperlinks, in Excel, there is no quick way can help you, however, with Kutools for Excel’s Convert Hyperlinks utility to quickly convert plain texts to linkable hyperlinks.
After free installing Kutools for Excel, please do as below:
1. Select texts that you want to convert to clickable hyperlinks, and click Kutools > Link > Convert Hyperlinks. See screenshot:
2. Then in the popping dialog, check Cell contents replace hyperlinks addresses option, and then check Convert source range checkbox. See screenshot:
3. Click Ok. Now the plain texts are converted to linkable hyperlinks.
Tip: If you want to keep the plain texts after conversion, you can uncheck Convert source range in the Convert Hyperlink dialog, and select a cell to put out the converted results.
Delete Hyperlinks or Convert Hyperlink
Related articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- To post as a guest, your comment is unpublished.My AutoCorrect Options in Excel 2010 is grayed out and not clickable, smh...
- To post as a guest, your comment is unpublished.Hello, if your autocorrect option is gray, maybe you have a mixed Microsoft Office version installed, you only need to copy the WINWORD.exe file from Office12 (or other number)folder to Office14 folder, and restart Word. Hope it helps.
- To post as a guest, your comment is unpublished.thank you, I just intall win10 and need to change re-setup excel
- To post as a guest, your comment is unpublished.Does changing this setting apply only to your session or is the option change saved to the spreadsheet itself. For example, I have a very large sheet used by multiple people, and we have data in it that Excel always wants to auto-convert to a hyperlink (not wanted). So if I change this option, am I doing it only for my self, or will this change apply to anyone (preferred option) that tries to edit this same spreadsheet?
Original KB number: 310049
Symptoms
Assume that you set Internet Explorer as your default browser in Windows. When you select a hyperlink in Microsoft Outlook, you receive one of the following error messages, depending on your Outlook version:
This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.
Your organization's policies are preventing us from completing this action for you. For more info, please contact your help desk.
Resolution
To resolve this problem, follow these methods in order. Check whether the problem is resolved after each method.
Method 1: Reset Internet Explorer settings
Internet Explorer 11 and Internet Explorer 10
Warning
If you are using Windows 10, Windows 8.1 or Windows 8, proceed to method 2.
Hyperlink Not Working In Excel
- Start Internet Explorer.
- Select Tools > Internet Options.
- Select Advanced > Reset.
- In the Reset Internet Explorer Settings window, select Delete personal settings > Reset.
- Select Close when it is completed.
- Close and restart Internet Explorer.
- Select Tools > Internet Options.
- Select Programs > Set programs.
- Select Set your default programs.
- In the Programs list, select Microsoft Outlook > Set this program as default.
- Scroll back up to the top of the default programs list and highlight Internet Explorer and select Set this program as default.
- Select OK, and close the Default Programs dialog box.
Internet Explorer 9
- Start Internet Explorer.
- Select Tools > Internet Options.
- Select Advanced > Reset.
- In the Reset Internet Explorer Settings window, select the Delete personal settings > Reset.
- Select Close when it is completed.
- Restart Internet Explorer.
- Select Tools > Internet Options.
- Select Programs > Set programs.
- Select Set your default programs.
- In the Programs list, select Microsoft Outlook > Set this program as default.
- Select OK, and then close the Default Programs dialog box.
- In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.
- Select OK.
Internet Explorer 8 and Internet Explorer 7
- Start Internet Explorer.
- On the Tools menu, select Internet Options.
- Select Advanced > Reset.
- Select Programs > Set programs.
- Select Set Default Programs.
- Select Microsoft Outlook > Set this program as default.
- Select OK, and then close the Default Programs dialog box.
- In the Internet Options dialog box, select the Programs tab, and then select Make default under Default web browser.
- Select OK.
Internet Explorer 6
- Start Internet Explorer.
- On the Tools menu, select Internet Options.
- Select Programs > Reset Web Settings.
- Under Internet programs, make sure that the correct email program is selected.
- Select the Internet Explorer should check to see whether it is the default browser check box.
- Select Apply > OK.NoteYou may receive the following message when Internet Explorer starts:
Internet Explorer is not currently your default browser. Would you like to make it your default browser?If you receive this message, select Yes.
Method 2 - Export and import the registry key from another computer
This section is intended for advanced computer users. For help with advanced troubleshooting, ask your system administrator or contact Microsoft Support.
Important
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
Note
Use this method only if the earlier instructions for each browser do not work to resolve this problem.
Step 1: Export the registry key from another computer
- On a computer that does not encounter this problem, select Start > Run.
- In the Open box, type regedit, and then select OK.
- Locate, and then select the registry subkey:
HKEY_LOCAL_MACHINESoftwareClasseshtmlfileshellopencommand
. - On the File or Registry menu (depending on your operating system), select Export.
- Note the location where the file will be saved.
- Type a unique file name, and then select Save.
- Exit Registry Editor.
Step 2: Import the registry key
- Copy the exported registry key to the desktop on the problem computer.
- Double-click the .reg file.You may receive the following message:Windows 10, Windows 8.1, and Windows 8Adding information can unintentionally change or delete values and cause components to stop working correctly. If you do not trust the source of this information in C:Users<yourlogon>Desktopregkey.reg, do not add it to the registry.Windows 7Are you sure you want to add the information in drive: location file was copied tofile name.reg to the registry?
- Select Yes > OK.
Step 3: Verify that the String (Default) value of the HKEY_CLASSES_ROOT .html key is htmlfile
Hyperlinks Not Working In Excel Office 365
- Select Start > Run.
- In the Open box, type regedit, and then select OK.
- Locate, and then select the registry subkey: HKEY_CLASSES_ROOT .html.
- Make sure that the value of the String (Default) is 'htmlfile'. If it's not htmlfile, right-click (Default), select Modify, input htmlfile in the Value data box, and then select OK.
- Exit Registry Editor.