Hyperlinks Not Working

Jan 21, 2010

The following is a simplified example of my problem: I have a list of product item numbers in column A. Next to each item number in column B, is a hyperlink to a PDF file relevant to each item. Elsewhere in the sheet, is a drop down box containing the item numbers. Next to the drop down box is a HYPERLINK(VLOOKUP) that fetches the relevant hyperlink depending upon the selected item in the drop down box. Problem is, when I select the ‘lookup’ link, I get an error message ‘cannot open the specified file’ (the original Hyperlink works fine). Does anyone have a solution to this problem (preferably without resorting to Visual Basic?

ADVERTISEMENT

Hyperlinks To Other Worksheets Not Working

May 25, 2013

I have a worksheet with with links to other workbooks. This has been working fine but a few days ago stopped working. I am getting a pop-up box.

An example of this is : Opening C:Business300635 Invoice.xlsm.

Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file? Yes or No.

When i click on Yes the busy icon appears for about 2 minutes and then disappears, not opening the file. I have tried to get this solved by going to Microsoft site for any possible clues. no luck there. I have uninstalled all updates to Microsoft and Excel to a point prior to the problem occurring, but to no avail. I can access the workbook I need to open by clicking the Office Button, and then searching for the relevant workbook.

The hyperlink formula I am using is " =HYPERLINK("C:Business"&P546&" Invoice.xlsm", "Invoice") ". The "&P546&" refers to the invoice number listed elsewhere in the worksheet.

View 2 Replies View Related

Can't Understand Why This Isn't Working - Hyperlinks

Jun 6, 2007

Trying to create a hyperlink in a worksheet to a new file saved under the name from the calling cell.

The file saveas function works great, but I cannot get the hyperlink to function correctly, and I've tried several ways.

The only way I can get a hyperlink to work and continually function is by manually creating it in the spreadsheet.

sub newjobcard()
FNAME = ActiveCell.Value
ActiveCell.Next.Select
ActiveCell.Formula = ("=HYPERLINK("y:FNAME" & ".XLS", FNAME)")
Workbooks.Add Template:= _
"Z:Peters computerPeters work FilesWTE FILESORIGINALS TEMPLATESJob Card.xls"
ActiveWorkbook.SaveAs Filename:="y:" & FNAME & ".xls"
End Sub

View 9 Replies View Related

Hyperlinks Stop Working When Page Is Sorted?

Oct 15, 2013

I have a Master sheet with data on it that corresponds with multiple sheets in the same workbook that I have links to in the Master sheet. It all works fine until I sort the Master and then my links start sending me to the wrong worksheet.

Is it just the nature of hyperlinks that you can't sort, or is something else going on here?

View 2 Replies View Related

Excel 2010 :: Hyperlinks Not Working When Spreadsheet Moved

Oct 17, 2013

Using MS Excel 2010.

As I understand it hyperlinks set in a spreadsheet should work regardless of where you save and/or copy the spreadsheet i.e. as long as the directory location of the location / file the hyperlink is referencing doesn't change (notwithstanding, the user must have appropriate access rights to the relevant directory locations)

However, the situation I have is the spreadsheet was generated and saved to directory location A (intention being this would be the 'master' yearly template) and the hyperlinks set, all of which work when you open the spreadsheet in this directory location. But when I copy the spreadsheet to directory location B, which is intended to be the yearly 'register' location for the spreadsheet, none of the hyperlinks work? When I hold my cursor over a link in the copied spreadsheet, in directory B, I do not get a 'pop-up' path like I do in directory A and when I click a link I get an error message:

Microsoft Excel The address of this site is not valid. Check the address and try again.

As stated above the documents the hyperlinks relate to have not moved, they remain in the same template directory (i.e. the link path has not altered).

View 1 Replies View Related

Loop Through Worksheets Not Working (delete Some Hyperlinks In Column A On 50+ Worksheets)

Jan 16, 2009

Just need to delete some hyperlinks in column A on 50+ worksheets. Thought a loop through all the worksheets would do it. Only works on active sheet. Forgive my ignorance, don't really even know where it goes, once it works - module or workbook?

View 2 Replies View Related

Explicit Hyperlinks, Relative Hyperlinks

Feb 21, 2007

I have a spreadsheet and within the first sheet there are lots of hyperlinks to other cells within sheet 1 (my template).

I have made a small macro which very basically makes a copy of sheet 1 (my template)

The hyperlinks in the template are explicit and as they are copied to sheet two, they still reference back to cells in sheet 1. I need the hyperlinks to be relative, so that when I make a copy of the template the hyperlinks are copied and make reference to cells in the new sheet. I cannot work out how this should be done

View 6 Replies View Related

Macros That Were Working In Excel 2003 Are Not Working In 2007

Jan 25, 2010

I have a workbook in excel 2003 which I had been running the following macros (listed below). We recently upgraded to Excel 07, and neither are working. When I try to run them, the "debug" option highlights the following line in the sort macro "Range("A2:z" & lastcell).Sort key1:=.Columns(1)". This is driving me crazy, as the macros worked perfectly under the older version of Microsoft. Is there an issue with crossfunctionality between '03 and '07'.

Private Sub Worksheet_change(ByVal target As Excel.Range)
If target.Column = 1 Then
ThisRow = target.Row
startRow = 1
i = 1
Set ws = ActiveSheet
maxRow = Cells.SpecialCells(xlLastCell).Row
maxCol = Cells.SpecialCells(xlLastCell).Column
ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
Do While i

View 9 Replies View Related

Hyperlinks

Jan 26, 2008

I have a spreadsheet that when an identity code is keyed in, it will display a make and model of a particular mobile phone, i want to put a hyperlink in the cell next to the phone name which will then open up an IE window to a website.

The thing i want ideally is if there is any way you can incorporate the websites search function into the hyperlink so when you click on it, the hyperlink will copy the phone details over to the website's search engine and take you straight to the online details of the phone?

wow this isnt making sense to me!

For e.g

The identity code shows up a Nokia 1500

The hyperlink next to it takes in the manufacturer/model details "nokia 5300" (these will obviously vary each time so takes in a cell reference should i say)

It opens up the ie window e.g "google" and automatically searches for that "nokia 5300" and comes up straight away with the search results.

View 9 Replies View Related

Hyperlinks With VBA

Feb 4, 2010

Is there a way of using something like hyperlinks in VBA code to open a user form?

I presently am using hyperlinks for coworkers to open other pages that resemble a user form.

I would like to change this to actually using user forms.

I would prefer to simply click on a person's name and open the form.

View 9 Replies View Related

Hyperlinks And Vlookups

Jan 31, 2013

I need returning a working hyperlink from a vlookup. I have a table with part #'s and hyperlinks. On another tab I want to type in a part number, have it search the table and return the working hyperlink. This will allow the user to just click it and go to that tab.

Here is my example spreadsheet : Book1.xlsm

View 2 Replies View Related

Sorting Hyperlinks

Jun 20, 2008

I created a data base that had a hyperlink to a plan of the store so we can find parts easy. With a lot of help for people here on this web site, it works very well.

My only problem now is that I sorted my Database by the hyperlink column. It made it easy to do one hyperlink and pull the fill handle down for the rest of the same hyperlink reference.

When I went to resort the database so that the parts were in alphabetical order. The sort worked well except that the hyperlink for lets say cell F87 was not sorted. Example : - F87 hyper link presort had the reference to Rack 10 self B. Post sort it had the reference to Rack 16 shelf C. But when clicked on it still took you to Rack 10 self B.

View 11 Replies View Related

PDF Hyperlinks In Cannot Open

Jun 9, 2009

When I click on a hyperlink inside an Excel spreadsheet, it is linked to a PDF file. When clicked, the screen flashes the Adobe Acrobat program for a split second and then disappears. But I can open the hyperlink same as which it is linked to a word file in the same directory.
I have gone into folder options and switched the PDF to open with Adobe reader 8, but that does nothing.

Any ideas of how to get the PDF to open and stay open would be most appreciated.

I tried to install adobe reader 4.0 without uninstall adobe 7.0 professional.
I use pdf reader 4.0 open the Pdf file in the window explorer, and then go to excel, open the same hypelink pdf file, and find it works now only opening pdf document by pdf reader 4.0 but not by 7.0.

But when I resinstall adobe 7.0 professional, and the problem still occurs. I have to open the original pdf file in the directory by adobe reader 4.0 again.

My case is like the following Macro in excel.
Setup hyperlink and open it . Then the problem is shown as my previous thread mentioned.

Sub Review() .....

View 6 Replies View Related

Vlookup Of Hyperlinks

Mar 12, 2009

I have a database of two columns - a file name and a hyperlink for the folder path to that form. What I would like to do is a VLOOKUP type search by the form name and the result be the hyperlink itself. The problem is that vlookup basically provides a "Values Only" response and doesn't carry over the hyperlink format.

View 2 Replies View Related

Editing Hyperlinks Using Vba?

Sep 8, 2009

I made the mistake of creating hyperlinks to files on a server (using the \SERVERNAME convention) without using the "hyperlink base" option.

I've been sufficiently chastened, but the present problem is that I have many such hyperlinks that are now worthless because, when saved, they point to "../../[foldername1]/[foldername2]/[filename]", etc.

Need macro that would replace the first five characters ("../..") of all the hyperlinks on my sheet with //[MYSERVERNAME] ?

View 7 Replies View Related

Combo Box And Hyperlinks

Oct 9, 2009

how to use a combo box to select hyperlinks to take you off to the selected website? I have this, which works but it's hard-coded - I'm looking for something a little more dynamic, i.e. pick up hyperlinks from a range on a sheet.

View 2 Replies View Related

Mesage Box And Hyperlinks

Jan 13, 2010

Can a message box support a hyperlink? I prompt a user with a message box with the text to a website, can the text for the website be a hyperlink in that message?

View 2 Replies View Related

If Function And Hyperlinks?

Feb 2, 2010

Have the following dilemma in Excel: If I enter a value in cell A3 and the value corresponds to a reference value in one of cells B4:B12, can I hyperlink data in cell range C4: C8 to elsewhere on the sheet (eg J4: J8).

Example.

I have 8 meeting rooms that each have a dedicated code, AU, BR, FOR, TO, M1, M2, M3, M4

When I enter a code in cell A3, (eg AU) I want the data in cells A4: A8 (date, start, end, event) to be reproduced in another table on the sheet.

In other words: If A3 is equivalent to a value in cells B4: B12, then can data in C4:C8 be reproduced in J4: J8?

View 6 Replies View Related

Dropdown Box And Hyperlinks

Aug 28, 2012

I'm trying to build a workbook that has a drop down box with 5 options. I want to be able to select an option out of the drop down menu, and have about 5 cells populate on that same sheet based on the what I select in the drop down box. I used Data Validation and List to make my drop down box, so that part is no problem. I can use an if statement to populate cells with names based on what I choose in the drop down box, so that's not really my problem either. The problem I have is that I was to make each name that populates based on what I select in the drop down box to be a hyperlink to a separate sheet within the same workbook.

I need these hyperlinks to go to different sheets based on what I choose from the drop down box. To tell you exactly what I'm doing: I have 5 locations. Each location has 3 to 5 supervisors. Each supervisors has 6 to 8 laborers under them. I want to have a drop down box with my location names. When I choose a location, I want to see the names of the supervisors at that location populate. I then want to be able to click on the name of the supervisor and have a hyperlink to a different page within that workbook to tell me data on the laborers under the supervisor..

View 1 Replies View Related

VBA To Not Follow Hyperlinks

Oct 17, 2013

Is there anyway in VBA, that if a hyperlink is clicked on in the spreadsheet that it won't follow the link?

I need it to be a link in every other respect because I will be parsing the Text to Display, and utilizing the links address. I just would like to not have the link be clickable on the spreadsheet.

View 9 Replies View Related

Hyperlinks From And To A Sheet

Mar 15, 2007

I have a workbook with 32 sheets. The first 31 sheets are hyperlinked to the 32nd sheet, which holds the summary from the other 31 sheets. Now, if I am in Sheet7 and click on the hyperlink in sheet7, it will take me to the summary sheet. That part is OK. But I want to know is it possible to go back to the sheet from where I reached the summary sheet (in this case sheet7 itself) with hyperlinks.

View 9 Replies View Related

Hyperlinks Within A Database

Apr 29, 2008

I am working on a database for a client. The database has a few worksheets with an overview (contents) worksheet. What I am trying to do is create a hyperlink from the contents page to the corresponding worksheet. I can do this no problem...my problem is that if I add more data to the worksheet the hyperlink is lost. I am linking the sheets via cells so if a cell is moved down to add a new cell the hyperlink is no longer valid. Is there a rule I can create to keep the hyperlink and not have to adjust it every time new data is added.

View 9 Replies View Related

Add A List Of Hyperlinks

Jun 4, 2009

i have a WB with over 28 sheets in is there any way of having a box wether it MsgBox or anything to give the user a choice of which sheet to goto , dont have room to add a list of hyperlinks , was wondering if this was possible atall

View 9 Replies View Related

Magic Hyperlinks

Jul 13, 2009

I have a database in excel. Each row in my database is usable information that has a link to Word files on our server and the database is saved on the server.

Whenever I move the original file which is on the server anywhere it causes all the hyperlinks to change. I have saved it on my desktop then moved it, and it still changes my hyperlinks. I don't understand why my hyperlinks don't just stay they way I created them.

Is there a way to keep my hyperlinks from changing? If you notice the immediate folder of the filename doesn't change.

Example:
Original hyperlink:
//server/reports/filename

Changed hyperlink:
C:/document and settings/user/microsoft/reports/filename

View 9 Replies View Related

Textbox And Hyperlinks

Jul 14, 2009

I have TextBox1 where I input a 1,2,3, etc...

In TextBox2, depending on the number input in Textbox1 I would like to assign a hyperlink to appear in TextBox2. I have been finding that this is nearly impossible. Are there any other viable options I should look at?

View 9 Replies View Related

Update Hyperlinks

Apr 21, 2006

I have a database in excel that has hyperlinks to each document. The problem i have is that i need to move the documents to a new folder, therefore rendering the hyperlinks useless. I have over 1000 hyperlinks that needs to be updated.

what i need to do is the change the current hyperlink to insert the name of the new folder that these documents are to be placed in.
i.e.

c:1 management........
needs to become
c:Registered folders1 Management........

Is there a way of adding the name Registered folders to the path of the hyperlinks for every document automatically, as doing this manually will be too time consuming.

View 5 Replies View Related

Hyperlinks To Hidden Sheets?

Jun 15, 2013

I have a worksheet with 28 sheets. I want the first sheet to be the only sheet displayed when opening the file and then want people to have the ability to click a hyperlink to unhide a particular sheet. Then when they go back to the main page (via another hyperlink), the sheet that was unhidden will be hidden again. I was able to put together some code from [URL]. When I click on a hyperlink on the main page, I get a "Subscript out of range" error and it highlights Sheets(strSheet).Visible=True from the Worksheet_FollowHyperlink code. I made a basic spreadsheet with just 3 sheets and plugged this code in and it worked fine so I'm not quite sure what the error is. I attached the spreadsheet I'm using.

View 3 Replies View Related

How To Match Hyperlinks With If Statement

Jul 12, 2013

Here the situation I have a list of around 2000 hyperlinks from my workbook and its various sheets. I have a pre made list of all the hyper links that there should be unfortunelty you know how things go and Im off by some here and there. What I need to figure out is how to match up my hyper link list to my pre made list. Im thinking an if statement looking for keys (truck #, Trailer #, Date) to get me the closest matches I can without having to go through every single hyper link....

Im thinking i need to match the criteria (truck #, Trailer #, Date) to that of the data i got from the hyper links. Ill explain more on my attached work sheet so it is more clear to under stand.....

View 1 Replies View Related

Create Range Of Hyperlinks Using VBA?

Aug 20, 2013

In column A I have a range of file path extensions (i.e., C:UsersJSmithDocumentsModelsHic Sunt DraconesTest.xlsx). What I want is a macro that will use those file path extensions to create hyperlinks in column B.

So far this is what I have:

VB:
Sub Hyperlink()
Range("a1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=Range("b1").Value, SubAddress:= _
"", TextToDisplay:="Link"
End Sub

This code works for the first cell, but does not work for the rest of the cells in the range. Also. Keep in mind that the range of cells in column A is dynamic - it changes in length.

View 5 Replies View Related

Edit The Hyperlinks In Sheet

Jul 31, 2007

I need to edit the hyperlinks in my excel sheet. I know how to do this manually and edit one at a time, but I need to change 3000 of them!

Is there a way I can do this without going through each one?

View 9 Replies View Related

How To Format Hyperlinks In TOC That Is Refreshed

Dec 6, 2012

So I have a code that creates a refreshable list of sheet names in a TOC (I call it a "directory" in the code). Problem is it creates the ugly standard hyper link look. I can format the look of the cells, of course, but when the refresh button is hit, the formatting is erased and it all goes back to the standard hyperlink blue underlined look. How to keep the formatting permanent?

Here is the macro I am using - [Code] ..........

View 1 Replies View Related

Formatting Cells For Hyperlinks

Mar 18, 2013

I have Excel 2003 & am trying to design a template for keeping track of my design products. I have several rows for links to previews, downloads etc. I use the template when placing merchandise in stores so I can copy/paste the info where needed. I want to copy links to a cell but have them be non-clickable. If I paste the link & then right click the cell & choose remove hyperlink I get non-clickable text, however I lose the original formatting for that cell.(left/center/wrap text).

View 2 Replies View Related

Dropdown List Of Hyperlinks

Oct 16, 2013

I have a large amount of sheets in a workbook (, say 70). For example:

1 GrandMastersheet of pets

.....1 Mastersheet of dogs
.................1 sheet of little dogs
.................1 sheet of big dogs
.................1 sheet of blue dogs
......1 Mastersheet of cats
.................1 sheet of black cats
.................1 sheet of white cats
.....1 Mastersheet of snakes ()
.................1 sheet of cobra's
etc. etc. etc.

The names of the sheets in the lowest level are quite long. Creating a icon with a macro/hyperlink in it is not what I want. (Boxes are too big and there would be too many boxes.)

This is what I would like: A clickable dropdownlist in the Mastersheets, that only show the lower level sheets of that category. For example:

A dropdownlist on the dogs Mastersheet that only show the words 'little dogs', 'big dogs' and 'blue dogs'. These words should be clickable and insta-hyperlinked to the specific sheet.

View 9 Replies View Related

How To Macro Hyperlinks Placed At The Right Cell

Jul 10, 2014

I have a macro (Photo_Hyperlinks2) that creates a hyperlink for every file found from a specific folder in Column A of Sheet 1.

The rest of Sheet 1 is my long version of doing what I want the macro to do... place the hyperlinks at the right spot. Sheet "Checksheet" makes a hyperlink of the already made hyperlinks (from Sheet 1) ONLY if the hyperlink in Sheet 1 is found. Same goes for the hyperlinks (1), (2), (3), and (4).

I really want to get rid of having to create a Sheet 1. I'm pretty sure there's a way to tell a macro to place the hyperlinks that contain "id" and/or "est" on the right row number in sheet Checksheet, and that if that row (in Checksheet Sheet) contains a (1) -(4), put it in the right cell, while also ommiting the first part of the name (ex: from 123445E(1) to (1)) ; I can live without that part if it can't be done.

Sheet "Checklist Using C-G Columns" shows the hidden columns not seen in Sheet "Checklist". Those manually inputed numbers are there mainly to tell that if more than 1 of the cells on the row are filled out, then to create a new row below it, and to continue the hyperlinking with (5), (6)... etc.

The final product is supposed to look like Sheet "Ideal Checksheet", except that ideally links (5)... etc. should work, and columns C-G are hidden again.

View 4 Replies View Related

Keeping Hyperlinks After Transpose

Aug 15, 2014

How can I get this macro to run without removing the hyperlinks from the 1st line of each group?

Sub Transpose()
sn = Sheets("sheet1").UsedRange.Columns(1).Resize(, 4)

For J = 1 To UBound(sn)
sn((J - 1) UBound(sn, 2) + 1, (J - 1) Mod UBound(sn, 2) + 1) = sn(J, 1)
Next

Sheets("sheet2").Cells(1).Resize(UBound(sn) UBound(sn, 2) + 1, UBound(sn, 2)) = sn
End Sub

View 1 Replies View Related

Hyperlinks And Sheet Names

Feb 27, 2007

I wrote the following macro to create hyperlinked Table of contents on the first sheet of a workbook. It works great unless the sheet name has a space in it, i.e. "new sheet" as opposed to "newsheet". Any way to get it to work for either/ or?


Originally Posted by Code

Sub Hyperlink()
'
' Hyperlink Macro
' Macro recorded 2/26/2007 by bpillsbu
'

'
Dim ShName As String
Dim ShCt, N As Integer
Dim Sht As Worksheet

ShCt = ThisWorkbook.Worksheets.Count
Range("A5").Select
N = 1

View 14 Replies View Related

Using A Macro To Create Hyperlinks

Jul 17, 2008

I currently have a macro that uploads information on a daily basis for hours worked on campaigns per employee. It then converts the data into a pivot table where it uses relative references to copy the total from the bottom and paste them on to another worksheet. I am now trying to use hyperlinks to link the total back to the pivot table. With daily updates though, the data is constantly being pushed down and is located in a new cell each time. How can I get a hyperlink to work for an area thats constantly changing?

View 9 Replies View Related

Hyperlinks And Blank Cells

Oct 30, 2008

I have many hyperlinks that are to blank cells, the cells may be blank now but can contain data at any time.

When the hyperlinked cell is blank the active cell displays a Zero (0), is there any way to make the cell appear blank like the hyperlinked cell?

View 8 Replies View Related

Hyperlinks From Drop Down Lists

Apr 18, 2009

I'm tring a different way to use hyperlink to other workbooks on my network.

I'm using a dropdown validation box and a button. I want to select from the dropdown a link. Not sure if the validation box is the way I should do this, maybe a form dropdown.

Basicly, I would like to use the drop down select the link and press the button to GO! to link.

Is it something like

HTML Hyperlink.follow (A1.value)

View 10 Replies View Related

Re-populating Hyperlinks That Have Been Cleared

Nov 3, 2009

I have a worksheet that I have removed a good number of hyperlinks, using the remove hyperlink function. My problem is that every so often, the hyperlinks are back on the sheet, without seeing any wording for the hyperlink.

Some place, a long time ago, I saw that there was something in the program that either stopped this from happening or turned the function off or a way of restoring removed hyperlinks. Today, I can't find it.

If I run my cursor over the spreadsheet, even over blank cells, I will get the evil finger of fate (so to speak) indicating that there is a hyperlink in that cell and yes, there is. If I click the cell, the site will be activated.

How do I keep these removed hyperlinks from returning.

I've also noticed that at anytime, while working on the sheet, everything flickers just as if the links are being re-populated. After a second or two the flickering stops and yes, the links are back.

View 12 Replies View Related

Hyperlinks Link To Other Worksheets

Nov 25, 2009

I have managed to find some code which, upon pressing a command button on the 1st worksheet in my workbook it:

1. populates a list of the names of all the other sheets in the document
2. converts each name into a hyperlink that when clicked, opens the sheet. (or at least it should)
3. Add the word 'menu' in cell A1 of each sheet that is a hyperlink back to the menu sheet

There are around 40 sheets in the document so you can see why this is easier than scrolling along the bottom to find the correct one. Or it should be.!

View 3 Replies View Related

ADVERTISEMENT