Free Microsoft Excel 2013 Quick Reference

Hyperlinks Results

I made an excel sheet that links to other sheets on a different drive. It works while I am making it, but upon save and reopen all the hyperlinks produce this error:

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

Any auggestions? Auto Merged Post Until 24 Hrs Passes;

Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive. Auto Merged Post Until 24 Hrs Passes;

Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive. Auto Merged Post Until 24 Hrs Passes;

Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive.

Figured it out. File, Properties, Summary tab, Hyperlink Box to base Drive.

How to create a hyperlink that when copied refers to a new cell?

We have recently updated our office server
the name was Procast-fs8
and is now Procast-fs6

eg old address Procast-fs8docsQualitysuper secret doc.xlsx

new address Procast-fs6docsQualitysuper secret doc.xlsx

we have a central quality control document in excel which uses hyperlinks there are around 5000 links in this document and i need to change all of them so they work with the new server address.

any help would be much appreciated

Hello, all.

I have a workbook with multiple worksheets that will be added or removed.

I want a list of all worksheets (which I plan on making hyperlinks) on the first worksheet. (entitled "Home"). This page is automatically selected on worksheet open.

In pseudocode, I want a:

OK - so that was even less than pseudocode, it's a quickie outline...
But the idea is present.

Can someone help me with how to set that up?
I believe it entails setting up the workbook as a workbook object - but I'm unfamiliar with how to do that, and to ensure I get it to properly cycle through the worksheets.

Any help would be greatly appreciated!

Trying to Hyperlink a cell in excel to open an existing email message in outlook.



I need to make a Workbook that has hyperlinks in the first sheet that links to a cell in a second sheet and then back again. The only way I have been able to do this is manually create each link in each sheet.

I am hoping that this process can be automated as they can not be 'filled' as far as I can see.

Please find attached an example of what I am trying to achieve.

Thanks in advance.
The Hobbit 81

Is it possible to copy hyperlinks when using a VBA advanced filter which copies the filtered data to another location?

Here is the code I'm using:

Range("A1:H33").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ 
"J4:O6"), CopyToRange:=Range("Overdue!A1"), Unique:=False 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Hello Everyone!

Trying to do this.

=HYPERLINK(INDEX(IndexLookup,MATCH(C4,Project,0),1), "Link")

Attached is an image of the predicament

Is it possible to hyperlink to a cell within the current workbook at all using the HYPERLINK function? dynamically?


I have done a quick search and dont find a similar problem.
in order to hyperlink a single peice of text in a cell and not the whole cell I have created a shape with no fill or line but added text. I then hyperlinked it to a location in the workbook. When I set the Move and size with cell property I am not geting the expected result. If I resize a row well above that cell, the object isn't following the cell it wa placed in.
I would be happy with alternative mechanisms for putting independantly linked text.

How can I check my Hyperlink's with sn "IF" formula?
I mean:

Is there a formula that does "if(a1=ok,"Good Link","BAD LINK!!!")

Hi there

Does anyone know if/ how i might unlock hyperlinks on my protected spreadsheet without having to unlock the cells they are placed in?

many thanks

hi everyone,

can anyone explain why no formula based hyperlinks will work in my workbook. even the simplest formula's. either it returns "cannot open specified file" or it does absolutely nothing even though the cursor acknowledges its a hyperlink.



I am trying to create a hyperlink to record 202 which is in the range C14:C250 on worksheet All in the active workbook (Frenchie), displaying the contents of cell Q3024 as the Friendly_Name. However, having tried many variations of both LOOKUP and VLOOKUP, my efforts are still returning "cannot open specified file" every time. is the formula faulted at all or should i be using another formula other than the LOOKUPs?

my formula is as follows.

=HYPERLINK("[Frenchie]All!, (LOOKUP(202,C14:C250))", Q3024)

thanks in advance.

any ideas why my hyperlink created with Insert>Hyperlink function is displayed as :


in the address in the edit hyperlink box? and how to solve this problem?


Hi all

Is there anything obviously wrong with this hyperlink formula. it won't function at all, Excel won't even recognise it as a hyperlink:

=HYPERLINK("C:Documents and SettingsjjDesktopEnailClaire's ProjColoursCOL NO 001.jpg","enlarge")

However, when i create the link using Insert>Hyperlink, the address displayed in the Edit Hyperlink box reads:


is this my problem? why are the spaces represented as '%20' ?

many thanks


I have an existing shared excel file in the office server which has hyperlinks to thousands of pdf drawing files. I'm creating a new file for my own updating purposes and I want to make a column for the hyperlinks to show up only if I don't have the updated drawings. I've basically completed my file except for the hyperlink part.

Can't really target the shared file cell (using "='[FileName]Worksheet'!B2") cause it will only give me back a text without the link.

Q1. Is there a way to copy the hyperlink to my own file? Without having to do it manually. I've tried other thing, but instead of giving me the correct link (sharedxyzdraw.pdf), it gave me back (flubberxyzdraw.pdf), which is my own computer name. Weird.

I've tried using an UDF, the GetAddress function (to extract the address from a hyperlink), from this website -> link. It worked, partially. Not sure because of the protected status or the file name is too long (the path name is indeed very long) or other thing, but the function gave me back "../engineering & drafting/1/2/3/4/5/6/7/8/4089.pdf".

From here own I can just remove the first 2 chars (the 2 '.') and add in the computer name in front of the text (using "=A1&B1"), where A1 -> "shared" and B1 -> "/engineering & drafting/1/2/3/4/5/6/7/8/4089.pdf". Then I just need to use the hyperlink function ("hyperlink=(C2,"Click")"), where C2 is the name of the complete path name to the file I want.

But now my problem is that I need to replace "/" in cell B1 to "". And the number of "/" in the path name is different for each file.

Q2. Is it possible to get a function to replace a specific character 'A' in a text to another character 'B', irregardless of the number of character 'A' that text has?

A bit too long I know, but any help will be appreciated. A bunch of thanks.


ps: When I'm using the GetAddress function, I can only get the address name if the shared file is opened. When the shared file is closed, it will only give me back "#VALUE!". But if you open the shared file again, it will automatically update and give me the correct address. Any ideas?

I have three columns. Column A="Name", Column B="Date" and Columnc="Amount".
I need to find and go to the correct amount based on a certain name and date as criteria.

I was going to see if it was possible to use this =INDEX(C1:C1000,MATCH(1,(A1:A1000=D1)*(B1:B1000=E1),0)) with a hyperlink, but I can't even get it to work without a hyperlink. I also tried this to find the match=SUMPRODUCT((A1:A1000=E5)*(B1:B1000=EE6)*(C1:C1000)). I found it on a website(I'm not sure how it works.) My next shot was going to be with multiple criteria vlookup, but I can't get anything more than a plain vlookup to work.

I'm using excel 2007 non-commercial use.
Thanks in advance for any replies.

Hi everybody, I would like to know if is possible to put an Hyperlink with code to do a Macro. I tryed to do it Recording it but nothing appeard in the Module.

Thanks to all

hi folks

Attached is the Demo test file in the ZIP file.

In Worksheet 1 you will see a dropdown picklist - it has been acheived by Using Data/Validation select list. However while it does work - to change the hyperlink what I would prefer it to do is as a user makes their choice/pick from the list they are taken straight away to the worksheet they have chosen -without the the need for the user to actually also have to click on the hyperlink then going to the worksheet. So what I am trying to achieve is one less interaction needed from the user.

Thanks in advance

Tony Mos

OK, it took me an hour to figure out how to ask a question, so here they are

1. How do I make it a global defualt on all my excel spreadsheet to ALWAYS have the text on the top of the cell and never at the bottom

2, How do I make it imppossible for hyperlinks to appear in my document. I print up lists with emaill addresses, and the hyperlinks drive me crazy since they launch an email. When I remove the hyperlink, the text appears on the bottom of the cell (see above note). I want to be able to type in email address and never deal with hyperlinks every

help me obeywankenobee your my only hope

No luck finding an answer? You could always try Google.