0
votes
0answers
20 views

Changing what browser Excel hyperlinks open in

Right now all of my hyperlinks in excel open with IE. I'm hyper-linking Google sites though, and I would prefer that they open in Chrome. How do I change what browser hyperlinks open in? There's no ...
1
vote
1answer
113 views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
0
votes
0answers
27 views

Add custom field (hyperlink) to a Pivot Table

I've made a Pivot Table that has one column called Issue Id. I would like to add a column to this table with the following formula: =HYPERLINK(CONCATENATE("website.com/", 'Issue Id'), 'Issue Id') ...
0
votes
1answer
56 views

is it possible to create a hyperlink in excel from the cell text? [duplicate]

like the title says, i want to see if its even possible to create a hyperlink with a pre-defined string of a url but the page be whatever the text in the sell is. example: say the A1 cell has TEST ...
3
votes
1answer
65 views

Toggled Hyperlink with If:Then formula [duplicate]

I'm attempting to make a formula that will toggle a hyperlink on or off depending on the argument. Basically, I want to make it argue the following: If there is text in (Tab A, Cell A), then create a ...
1
vote
2answers
167 views

Hyperlinks to web pages in my Excel workbook don't work now

Hyperlinks to web pages, saved in my Excel workbook don't work after upgrade to Windows 7 & new hard drive. Have had this spreadsheet for years. I was always able to click on the link and it ...
0
votes
1answer
169 views

How do I prevent Excel from changing the color of a clicked link?

I'm using Excel 2010. And as most Excel users know, if a cell is also a link, once you click it it turns to this awful purple color. For me this ruins the color coding I'm using to show the status ...
2
votes
3answers
209 views

Automatically hyperlink-ify large number cells containing URLs in Excel 2010

I have an Excel spreadsheet with around 900 cells each of which contains a URL, which I've pasted in from another program. If I select a cell and hit F2, then hit Enter, Excel adds a hyperlink to the ...
0
votes
1answer
378 views

Extract URL from anchor Text in Excel

I've looked through this thread for something that fits my query but most of the topics came close but wasn't specific to mine. I'm trying to extract the URL from an anchor text in Excel. Is there a ...
0
votes
1answer
252 views

Hyperlink in excel not redirecting to correct page [duplicate]

I have reviewed a similar question that was asked previously on here but couldn't find my answer. I am hyperlinking to http://uk.eurosport.yahoo.com/fantasy/premier-league/details/39215 from a cell ...
0
votes
0answers
241 views

Hyperlinks with permalinks do not work on Microsoft Excel

In Microsoft Excel, I go to a cell and create a hyperlink to a PDF document as follows: http://mysite.com/MyDocument.pdf#page10 Unfortunately, when I click to it my web browser(Chrome) goes to the ...
4
votes
2answers
6k views

How can I change a hyperlink's default open-with behaviour in Excel?

Using Office 2010 running on Windows 7, I have a hyperlink in Excel to a JPG on a drive: =HYPERLINK("\\myserver\dir1\file.jpg", "Link") The problem: when clicked in Excel, this link ONLY opens in ...
3
votes
1answer
7k views

Can I use an excel formula to extract the link location of a hyperlink in a cell?

I have a spreadsheet with a large number of cells containing hyperlinks with display text different than the hyperlink location ie: cell location: A1 display text = "Site Info" hyperlink location ...
6
votes
1answer
4k views

How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC Project A A.pdf A.pdf Project B No Link I have a list of project records. One column (e.g., B) ...
2
votes
1answer
2k views

How to find hyperlinks in Excel 2010 and de-activate them?

When opening my Excel sheet using Excel 2010, I get a yellow bar at the top from Excel informing me that it has de-activated the automatic update of hyperlinks. To my best knowledge, I do not know ...
1
vote
2answers
3k views

Excel (2010) HYPERLINK: how to call a file with command line arguments and spaces in the path?

I am working on an Excel-document to make a (project-)folder structure manageable, using HYPERLINKs to important files and folders (Word/Excel, etc.). Since we are also using TFS, I want to add the ...
2
votes
1answer
85 views

Excel 2007 hyperlinks to other workbooks not redirecting properly

Links within the workbook seem solid. Links to other workbooks on the network get replaced with C-drive home directory addresses.
1
vote
1answer
579 views

Open Excel files from Hyperlink in new window

Much like this question but I want to be able to insert a Hyperlink into one sheet that opens another sheet in a new window. P.S. Using Excel 2007
3
votes
1answer
510 views

link cell text to file of the same name

i have a workbook in excel and in one column i am putting the names of images. i want to create a macro/vba code so that when i type in the file name into the column e.g. IMG_1234 it will ...
0
votes
4answers
4k views

Copying a hyperlink so that it works with a series

OK, this should be a no-brainer, but I cannot find anyone to help me with this: Example A5-K5 On worksheet 1 contains info relating to one specific item. I want to have a hyperlink in L5 taking me to ...
7
votes
5answers
10k views

Excel hyperlink not redirecting properly (bug?)

I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the ...
1
vote
2answers
2k views

Excel: make HYPERLINK and INDIRECT to work on the same sheet

I have an excel workbook (Global.xlsx) which contains hyperlinks (=HYPERLINK(...) ) to other workbooks (representing experiments I've taken, named Exp1, Exp2, etc.), and some data that describe the ...
1
vote
1answer
2k views

Hyperlinking a piece of text in Excel

I'm using Excel 2010 and I have a simple problem where I need to hyperlink a certain part of my text. My cell content is as simple as "For blablabla, click here." I want to add a hyperlink to the ...
0
votes
2answers
487 views

Microsoft Office Excel 2007 - Hyperlink Query

I am currently working on a spreadsheet where I am referencing drawings throughout the document. I have the drawings saved in the same folder as the spreadsheet. When sending the document externally ...
1
vote
2answers
245 views

Linking a cell to a tab within an Excel workbook

I'm using Microsoft Excel 2011. One of my workbooks contains a tab. I want that tab to open when I click a link. The link should be in a cell in the same workbook. How can I create such a link?
1
vote
1answer
572 views

How do I Transfer the Cell Data from one Column to the Hyperlink Address for a Corresponding Column's cells?

How do I transfer the cell data from one column to the Hyperlink address for a corresponding column's cells in Excel 2010? Example: Cell F4: www.microsoft.com Cell F5: www.google.com Cell C4: ...
3
votes
1answer
630 views

Excel hyperlinks can be attached to a range of cells — What would be a plausible use of this feature?

Background: I'm the author/maintainer of xlrd, a Python package for reading Excel 97-2003 XLS files. I'm in the process of enhancing to extract information about hyperlinks. My reason for asking this ...
2
votes
8answers
15k views

Create PDF with internal hyperlinks

I have an Excel workbook with an index page containing a series of images, that are each hyperlinked to different worksheets. Can anybody suggest how I can publish this to PDF so that the hyperlinks ...
2
votes
1answer
1k views

Hyperlink in Excel

I am using MS Excel 2007 (previously familiar with Excel 2003). I create a simple hyperlink in cell A1 (in sheet Sheet1) so when I click cell A1, the cursor moves to cell B10. It's very easy, no ...
7
votes
1answer
3k views

Excel automatic hyperlinks

After years of not wanting Word and Excel to automatically turn things into hyperlinks, the one time I want them to they refuse. I have a list of strings in Excel which I am concatenating with a ...