#1
|
|||
|
|||
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 |
|
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 |