Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations KootK on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

opening links (to other workbooks) ? 1

Status
Not open for further replies.
rb1957

rb1957

Aerospace
Apr 15, 2005
15,666
ok, dumba$$ I know, but ...

I've created a bunch of links to other workbooks within the same folder, and pasted into a s/sht (did this maybe a year ago).

Now I'm looking at the s/sht (with the links pasted in it). I can see the pasted link (in the cell contents).

But how do I open that link ?

thx

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Replies continue below

Recommended for you

Sort by date Sort by votes
thx, but no joy ... CNTL left click, right click, double click ...

if I go to the Links menu, it want to add a link.

is it possible that the links have become broken ? No obvious way to "update" ?

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Upvote 0 Downvote
if you hover over the cell, does it show a file path for the hyperlink? it should; I just tried it here, Insert ribbon, Link, Insert Link, selected a file. When I left click on the link it opens the spreadsheet in Excel.
 
Upvote 0 Downvote
Can you post an example workbook? ... I could, but would take too long to sanitize ...
posted a screen shot ... shows a cell contents as the link address (and cell displays the link value). I copied the link address into the file ('cause I don't trust these things !).

I remember setting up the links ... found the files needed to be in the same folder (PITA).
The cell contents show the link address, and display the linked value, but no amount of clicking will open the lin ?

The folder in question is a network folder, the address is still valid ('cause I can manually open the source).

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Upvote 0 Downvote
In the Data tab menu, find "Workbook Links"
 
Upvote 0 Downvote
the closest I get (with Excel ... IDK !?) is a "connections" tab. Ok, click "edit" and I get a list of links, which I can "open source" but this is a PITA.

I can't quickly open the source ??



"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
 https://files.engineering.com/getfile.aspx?folder=0f11d843-a5d6-4e1d-81ab-bee022f46ab7&file=Screen_Shot_01-05-24_at_01.31_PM.PNG
Upvote 0 Downvote
The simplest thing to do, I think, is to use an adjacent column and insert "=hyperlink(I34)" etc. which will create a hyperlink similar to what you might have gotten had you used the "Insert Link" toolbar command originally.

hyper_vw1n1h.png


Alternately, you could create a macro to copy the contents of each cell with a link and do a proper Insert Link



TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list
 
Upvote 0 Downvote
Code: 
Sub Macro2()
'
' Macro2 Macro
'

'
    target = Range("A1").Value
    Range("B1").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
        target, TextToDisplay:=target
End Sub

results in
hyper2_nzhkzk.png


TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list
 
Upvote 0 Downvote
I've created a bunch of links to other workbooks within the same folder
Click to expand...

1. For what purpose? Just a reference or to access data?

2. If the latter, is this tabular data or data in a discrete cell?

3. In order to suggest a method other than a hyperlink, I'd need to understand the what and why of this/these link(s).

4. I've created data acquisition methods to get data from various data sources, given a set of 1 or more arguments. The routines for these methods/functions would reside in a Personal.xlsb hidden workbook that opens every time you open Excel and perform as any other spreadsheet function.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Upvote 0 Downvote
When you first open the file does it give you an option to enable or disable anything?

1) If the cell contains a formula that picks up a value from a cell or range in another workbook, that is not clickable to open that file.

2) If the cell contains text that happens to be a fully qualified file name it is just that, not a link.

3) If the cell contains text that was inserted as a link, it does just that. You can tell because the mouse pointer changes shape.

4) If the cell is contains the formrula =FormulaText(R1C1) then it is just a formul and not a clickable link.

Converting 2 to 3 requires one of the suggestions above

Question: did this ever work as desired?


 
Upvote 0 Downvote
thx IR ... you put in more effort than I usually would !

@Skip, it's a table of MS ... the different work books to a bunch of calcs, I'm linking to the critical MS to make it easy to find.

@IFR ... the cell contents look like links, the cell value is the value at the specific cell. I have a memory of when I did this (a year ago) of checking things, and thought it opened the other workbook as expected.

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Upvote 0 Downvote
No worries; I figured the first approach was good enough for a one-off, but I was curious to know if it was possible to "fix" the links, which it looks like they can be, so copying the value of the cell and then doing "Insert Link" would fix the links without the extra column.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list
 
Upvote 0 Downvote
If you make the links relative paths it helps to reduce the risk of broken links when things move around (this assumes all of the files are in a single folder and everything is moved together).

If all of your files are in C:\webtemp\foo
C:\webtemp\foo\data.xlsx
becomes relative path
.\data.xlsx

First create the link using the excel link tool, then edit the resulting pathname.
 
Upvote 0 Downvote
ok, good idea, I'll look into it.

But the cell contents show the proper link, report the proper value, just clicking the link does nothing ?
when I'm sure it used to (and nothing's moved)

BTW, it is a network drive.

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Upvote 0 Downvote
Since it's on a network drive, are you referencing mapped drive letters? If so, you might change those to the "\\network\" format.

<tg>

 
Upvote 0 Downvote
But the cell contents show the proper link, report the proper value, just clicking the link does nothing ?
when I'm sure it used to (and nothing's moved)
Click to expand...

That's because it's just string data; it's not a link unless "Insert Link" was activated. The XML versions of the spreadsheet shows that the cell content includes an extra field that identifies as a hyperlink, which is distinct from the displayed contents, just like the Eng-Tips TGML hyperlinks allowing for a display being different from the actual link. So, in Excel, you have to have explicitly used "Insert Link" to get a clickable link.

<Cell ss:StyleID="s62" ss:HRef=" ss:Type="String">vs.
<Cell><Data ss:Type="String">
The former shows that the "Cell" has a hyperlink HRef, as well as the displayed "Data" string while the latter shows only. Note that ET's TGML took over the link strings above, so that's not Excel doing that.





TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list
 
Upvote 0 Downvote
I'm pretty sure they were created by "insert links", and I copied the cell "string data" address to a different cell, and pasted as text (so I have the address).

"Hoffen wir mal, dass alles gut geht !"
General Paulus, Nov 1942, outside Stalingrad after the launch of Operation Uranus.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Denial
  • Locked
  • Question
Early alternative to ISFORMULA() function 1
2
Replies
20
Views
431
3DDave
3DDave
3DDave
  • Locked
  • Question
Only 30 years to fix this
Replies
5
Views
253
SkipVought
SkipVought
As-Lag
  • Locked
  • Question
Broken Links in the name manager that repair when read only
Replies
4
Views
95
As-Lag
As-Lag
vinodnx7
  • Locked
  • Question
Micro to compare two excel file for mirror change
Replies
4
Views
294
vinodnx7
vinodnx7
skeletron
  • Locked
  • Question
Footers and Page Break boundaries with print-to-PDF
Replies
3
Views
103
3DDave
3DDave

Part and Inventory Search

Sponsor

Back
Top Bottom