Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-26-2015, 10:43 AM
MarkH MarkH is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2015
Posts: 1
MarkH is on a distinguished road
Default Hyperlink formula returning 'invalid site address'

I am trying to include 'hyperlink' inside a formula but am encountering difficulties. Even when I use just hyperlink as a formula on its own, it accepts the formula but returns an error message.
Ultimately the user will select a month from a drop down list, the hyperlink will take them to the relevant sheet (one for each month), any help in achieving this would be much appreciated.
Thanks from a newbie.

Hi All
I think I have found the solution on another site. You need to include the # symbol at the beginning of the formula argument to direct it to a local sheet. So for example the expression would look like this =HYPERLINK("#"&J7&"!"&"A1","Sheet 7")


This detail is not included in the Microsoft Help material.
Hope this helps someone else.

Last edited by MarkH; 12-27-2015 at 03:05 AM. Reason: Solution found
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mass Change of Text to Display in Hyperlink to actual address ItsChris Excel 3 10-18-2014 01:35 PM
Problems when opening previous version of .mpp file from Site Assets in SharePoint site Laibiang Project 11 10-17-2014 05:28 AM
Cant unformat email address hyperlink in Excel the way HELP says I can tomseeley Excel 11 01-24-2014 05:50 PM
Inserting an Email Address with hyperlink into a Mail Merge Letter AClaborn Mail Merge 3 10-15-2013 04:02 PM
Hyperlink address fields from Excel BongoBill Word 0 04-13-2010 04:27 AM


All times are GMT -7. The time now is 11:37 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft