Hyperlinks Within Same Workbook

  • Thread starter Thread starter John Gregory
  • Start date Start date
J

John Gregory

I'm having a heck of a time creating hyperlinks in a workbook I received
from someone. Essentially, I added sheets and drew graphs. One of those
sheets I plan to make an index with this structure:



! Leading Indicators

MZM

1,1a REIT

1.1b Pipeline

1.1c Household - nondurable

Stock Market

S&P 500

1.2a REIT

1.2b Pipeline

1.1c Household - nondurable

2 Coincident Indicators

T-Bills

2.1a REIT

2.1b Pipeline

2.1c Household - nondurable



The Tabs run concurrently as follows:

Index

1.1a) MZM

1.1b) MZM (2)

1.1c) MZM (3)

1.2a) S&P

1.2b) S&P (2)

1.2c) S&P (3)

Data

REITRESID

Pipelines



Now when I click the Hyperlink button on the tool bar and set it to make a
link within the same workbook, all I see is the tabs that have no numbers in
front of them. I then removed the "1.1a" fro the MZM tab and looked at the
hyperlink window again. The altered tab didn't appear.



Maybe I'm too close to the trees with this one. I've linked many times in
the past and never had the slightest problem. Anyone have a clue to what I
might be overlooking here?
 
I may have found something that will help resolve this quicker since there's
obviously too much here for someone to dig into.

When I pulled up the Properties window and displayed the "Contents" tab, low
and behold are all the tabs I made.... but they're listed as "Charts".
"Worksheets" are list 1st, containing only the original one I received then
comes a separate listing for "Charts". And the list is correct; what I added
were, in fact, charts. Problem is... I can't seem to make hyperlinks to
those tabs.
 
Hi John,
I don't know if this applies to your situation or not, but
if you have object type hyperlinks between two or more sheets
and want to make a copy so you can change the data,
for a graph on a different page, then group the related sheets
and then copy use
edit, copy sheets
You can then rename the sheets and the hyperlinks will be
corrected (object type hyperlinks *ONLY*,
not HYPERLINK Worksheet Functions).
 
if you have object type hyperlinks between two or more sheets<<

I don't understand, Dave. I have no hyperlinks at all at this point and
there were none on the original I modified. If you mean sheets of "charts",
then I do have those in between the worksheets that do appear on the outline
of items that can possibly be hyperlinked. No charts appear, however.



When I made my charts, I didn't group them but I did use Edit/CopySheets.



We're dealing with object type hyperlinks; no functions.
 
You say you have no hyperlinks, but you have hyperlinks
in the subject and in the last paragraph of your reply. ????

Hyperlinks aside if you have references from a chart to
another spreadsheet (where you have the data)
you want to group them so the
references remain linked together. If you copy them
separately then you will have broken the references.
 
Sorry for the confusion, David. I didn't have hyperlinks ... I referred to
"possible" hyperlinks; those options to link to that appeared in the
hyperlink window when an attempt were made.

In any event, I discovered that "Chart/Location" permitted me to move the
chart as an object to a new worksheet. That new worksheet showed up in the
hyperlink window, I renamed it, made a few adjustments to the new chart, and
everything came out fine. I can hyperlink the new chart. Thanks for your
help.
 
Hi John,
Maybe it doesn't apply to your situation.

I was trying to describe how you could copy the data on
one sheet and dependent graph(s) on another sheet
together as a group. So that if you change the
data, then the dependent graph(s) would change accordingly.

Certainly did not want the data on same sheet as the
graphs, Printed on a color printer (about a 1 or 2 inch color ribbon).
We used the black ribbons until the printing almost disappeared.
Eventually, I think, I printed on a color PostScript laser printer in
another department.

This was how I changed Monthly Graphs (3-D representations
of mainframe CPU utilization for each hour in a month), so that
all I did was copy the groups for a new month. Plop in the new
data, and change the titles on the graphs.

No hyperlinks, Excel didn't even have them then.
 
Back
Top