Tagged Questions
0
votes
0answers
13 views
Can I use an excel formula to extract the link location of a hyperlink in a cell? [migrated]
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 ...
0
votes
0answers
10 views
Possibility to use hyperlinks in a shared excel workbook
I've got an excel document where we've enabled the "Track Changes" functionality in order to capture who's changes what and when - for this you'd have to share the workbook.
We've now found that we ...
0
votes
1answer
38 views
How to update live links in PPT from Excel - while in Slideshow mode
I have pasted (paste special, paste link) data a cell in Excel into PPT.
I update the excel data and simultaneously I can see the data change in the PPT slide (edit mode)
However, when I run the PPT ...
-1
votes
0answers
44 views
Display Multiple Images From URL in Excel 2010 in specified cells [closed]
This is the first time i ever tried a forum like this. Please help me.
Excel 2010.
In B-column i have an array of products. In C-column i have an array of URL:s (Hyperlink:)
To the right of these ...
0
votes
0answers
60 views
PHP Excel image link
I am using PHP Excel library and have a problem.
I need to insert into a cell image as hyperlink. Is it possible, any suggesions?
Tryed to dran an image
$image = ...
1
vote
1answer
218 views
Populating a listbox in Outlook from an Excel Range - getting a cell's hyperlink
I'm trying to populate a multicolumn listbox in Outlook VBA with data from an Excel range.
I've managed to get it working so far using the code:
Private Sub CommandButton1_Click()
'Late binding. ...
0
votes
1answer
50 views
Removing hyperlinks, retaining formulas and format
I'm not very good with Excel but I'm going to try and explain my problem. Somehow an excel was created via a Timer and somehow has 100's of invisible hyperlinks spread throughout the sheet. I am ...
-1
votes
1answer
188 views
Create hyperlink from text in another cell in excel
I am trying to add a hyperlink (a href="url/category/H5")text(/a) to the beginning of cell B5 referencing H5. I think a VBA macro is probably the best way, but if it can be done using just formulas ...
0
votes
0answers
54 views
In Excel, can I get Data From an External Source (Oracle) that uses the =HYPERLINK(“http://url.com”, “Pretty Name”) function?
I'm trying to get my URLs in my Pivot Table / Pivot Chart to display as hyperlinks.
I've set up a connection, "From Other Sources," in my case Oracle. In the SQL statement, I say,
SELECT ...
0
votes
1answer
85 views
Not getting the total from another sheet after hyperlink is read because of multiple hyperlinks
I'm running few macros to count the words, characters, paragraphs and others of the text in column B. However some of the text in column B are hyperlinks.
The Output Sheet:
Right now, I have ...
0
votes
1answer
135 views
Excel dynamic hyperlink sheet navigation
I have a dynamic hyperlink that selects the last cell in a specified column within a sheet, regardless of th number of items in that column. So if I have 22 items in a column, the link will select the ...
-1
votes
1answer
77 views
how write hyperlink to local picture into the cell in openpyxl?
I use Python 2.7.3
I need to write hyperlink to local picture into the cell by openpyxl library.
when I need add hyperlink to web site I write something like this:
from openpyxl import Workbook
wb ...
1
vote
2answers
45 views
On click search and go cell in workbook
I would like to know if anyone can help me on this one.
I have a workbook with several tabs and a main page.
On the main page i have a top 20 of issues that are populated automatically.
What i want ...
1
vote
1answer
1k views
Macro to open Excel hyperlink does not work when hyperlink generated with a formula
There seems to be a bug with Excel hyperlinks which are generated with a formula. I'm using Excel 2010. I have a spreadsheet with cells containing URLs, and my goal is to do the following two ...
0
votes
1answer
171 views
Link excel data point by hyperlink
I have a graph with several data series on it, and in each series several points. I want to click on one point and have a jpeg or text file open.
Is it possible to hyperlink a data point on a excel ...
