×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

opening links (to other workbooks) ?

opening links (to other workbooks) ?

opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

probably hold "CNTL" key down while clicking

RE: opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

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.

RE: opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

In the Data tab menu, find "Workbook Links"

RE: opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

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.



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! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: opening links (to other workbooks) ?

CODE --> VBA

Sub Macro2()
'
' Macro2 Macro
'

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

results in

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: opening links (to other workbooks) ?

Quote:

I've created a bunch of links to other workbooks within the same folder

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: opening links (to other workbooks) ?

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?


RE: opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

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! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: opening links (to other workbooks) ?

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.

RE: opening links (to other workbooks) ?

(OP)
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.

RE: opening links (to other workbooks) ?

Since it's on a network drive, are you referencing mapped drive letters? If so, you might change those to the "\\network\" format.

<tg>

http://xdi.me

RE: opening links (to other workbooks) ?

Quote:

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)

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="https://www.eng-tips.com/viewthread.cfm?qid=515197..."><Data ss:Type="String">https://www.eng-tips.com/viewthread.cfm?qid=515197...;
vs.
<Cell><Data ss:Type="String">https://www.eng-tips.com/viewthread.cfm?qid=515197...;

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! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: opening links (to other workbooks) ?

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close