Add a Hyperlink

  1. Prepare the URL link in your database tables.

  2. In the Data Models and Views tab, right-click and select New Data Model to create a Data Model.
  3. In the Data Model Designer, set up the Format field:

    1. In the Categories section, select Hyperlink and click OK.

    2. In the upper left-hand corner, click File and select Save Data Model.
  4. Back to the Data Model and Views tab, create a New View from the Data model where you set up the Format field and select Worksheet.
  5. Add the Hyperlink (URL) fields.

  6. By clicking the link in the worksheet grid, a new window will open to display the URL in a browser.

Important

If you do an export of the worksheet containing the hyperlink, please proceed as follows before opening the file in Excel:

  • Open the link in your browser and make sure to select any option that will save the session data in cookies (like the Remember me feature when logging in) (right after the links should work on other browsers)
    OR
  • Change the registry key value: (Please refer to this link for more information.)
    1. Quit any programs that are running.
    2. Press the Windows + R keys to open the Run window.
    3. Enter regedit and press the Enter key.
    4. In the Registry Editor, browse to one of the following subkey (create the keys when they do not exist):
      1. For a 32 Bit version of Office on 64 bit version of WindowsHKLM\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internet\
      2. For a 32 Bit version of Office on 32 bit version of WindowsHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet
      3. For a 64 Bit version of Office on 64 bit version of WindowsHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internet
    5. Right-click on the Internet Subkey, click on Edit and select New then DWORD.
    6. Enter ForceShellExecute as Value Name and open it.
    7. Set the Value Data to 1 and click on OK.
    8. In the Registry Editor, click on File and select Exit.

Please note that using the ForceShell method will bring some differences regarding Office behavior.

  • Difference 1: Files opened from Office will open in separate instances
  • Difference 2: A linked workbook does not open when you click a hyperlink in an Excel 2013 workbook
  • Difference 3: A second presentation does not start until the original presentation is finished in PowerPoint
  • Difference 4: A warning message will come up when opening files from within Office
  • Difference 5: Links to Excel open without going to the right sheet, and links to Word open without going to the right bookmark

For more details regarding those differences, click here to visit the Microsoft Documentation.