+ Reply to Thread
Results 1 to 2 of 2

#value! Error on hyperlink formula

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Scotland
    MS-Off Ver
    2013
    Posts
    1

    #value! Error on hyperlink formula

    so i have tried everywhere for an answer to this hopefully someone can help.

    i have a spreadsheet which uses cells to populate information to generate an email with subject and body of text.

    This has been working with no issues for a while until now. I enter in appropriate information for example

    cell A2 = Robert
    cell B2 = Hoskins
    cell C2 = reference number

    cell H2 = hyperlink showing text “EMail”

    This has been working great so i click on the Email hyperlink and it opens my email with the correct email address and in the subject line it says
    Robert Hoskins 123456

    Until now, now if i change either the firstname or lastname to more than 10 characters the email hyperlink changes to #value!. I have double checked everything and cant see the problem. I have gone back to original sheet and i can input more than 20 characters in one cell and it works fine. I make a copy of the sheet or change text anywhere (not formulas) and it reverts back to the 10 char limit. All help gratefully welcomed.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: #value! Error on hyperlink formula

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] What is the hyperlink formula to create a hyperlink in Excel to a bookmark in Word
    By BryanHCR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2019, 11:41 PM
  2. Hyperlink to hidden sheet using a cell with the =Hyperlink formula
    By pauldonnelly16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2018, 07:53 PM
  3. Replies: 8
    Last Post: 06-27-2017, 10:36 AM
  4. [SOLVED] With Hyperlink formula & vba, I want to copy text of hyperlink to the cell it's linked to
    By Freakytone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2017, 05:46 PM
  5. [SOLVED] Error in my simple Hyperlink Formula
    By NewYears1978 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-14-2016, 02:37 PM
  6. Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  7. Hyperlink error
    By pmguerra in forum Excel General
    Replies: 4
    Last Post: 03-01-2010, 09:13 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1