Linking to Objects in Worksheet

T

tt1

Is it possible to link to an object on another worksheet in the sam
workbook. I can't seem to do that. The workbooks is N:\Claim
highlights\NY Highlights Templates.xls, the worksheet is Charts and th
named region on the worksheet is test. Any help would be greatl
appreciated
 
E

Ed Ferrero

Hi tt1,
Is it possible to link to an object on another worksheet in the same
workbook. I can't seem to do that. The workbooks is N:\Claims
highlights\NY Highlights Templates.xls, the worksheet is Charts and the
named region on the worksheet is test. Any help would be greatly
appreciated.
Click to expand...

Not sure what you want to do, but here are three things to try;

1) Use formulas to bring the values across.
=Sheet1!A1 will show the value of cell A1 in Sheet1

2) Use hyperlinks to link to data in the workbook.
Use the menu item Insert - Hyperlink
Click on Place in This Document on the left column
Select the defined name to link to from the list shown

3) Use the camera tool to create a picture of a worksheet
range that updates in real time.
Right-click a toolbar and choose Customize from the menu
Click on the Commands Tab, choose the Tools category,
scroll down in the commands list until you see the Camera
button (it is a fair way down). Drag the Camera button
onto one of your existing toolbars.

Now select a range and click the Camera button, then click
somewhere on a worksheet - the range is copied as a linked
picture. Change cell contents in the original range - the
picture changes too.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com
 
D

DerekB

Coincidence or not? The only references to "Camera tool" are in replies to
two different questions on the same day.

Why is this tool so carefully hidden? Looking into the Knowledge Base, I get
the impression that it was supposed to have disappeared sometime around Excel
95. I first became aware of it when using Excel 97 and by then no trace of it
could be found in the Help texts. I suddenly had a need for it recently and
it took some effort to find it again. The semi-hidden "Copy Picture" function
(Shift Edit is needed to locate it) is not as good as it is a static copy and
is not updated when the source changes.

In an attempt to find out more about the camera tool, I tried to see the
equivalent Visual Basic commands by using Record Macro but the secret is so
well protected that it doesn't work when Record Macro is running and so I
failed to learn anything.

There are situations where this is the perfect way to summarise data in a
large multi-worksheet file. It's a pity it cannot be brought back into the
range of easily accessible tools.
 
N

Norman Jones

Hi Derek,
The semi-hidden "Copy Picture" function
(Shift Edit is needed to locate it) is not as good as it is a static copy
and
is not updated when the source changes.
Click to expand...

Try:

Shift - Edit | Paste Picture Link
 
N

Norman Jones

Hi Derek,

Additionally, you can add a Camera icon to a toolbar you will find it via:

View | Toolbars | Customise | Commands | Tools
 
Top