Linked Picture?

**DCSwearingen** · 06-13-2006, 11:40 AM

I think I read somewhere that a picture of a workbook object could be pasted into other MS Office documents, but the picture coulb be linked to the workbook so that changes could be made to the workbook and they would show up in the other MS Office document.

This supposedly saves file size as the entire workbook is not embedded into the other document.

Does anyone know of this technique? If it does exist, how is it done?

**DCSwearingen** · 08-03-2006, 07:52 PM

I know this is an old post, but I see there have been 15 views so some people must be interested.

I found a different solution, but...

I stumbled on how to paste a picture on one of the MVP sites, I believe it was Jon Peltier's site?

Simply hold the Shift key click on Edit, and some new features are present, including Copy Picture and Paste Picture.

I don't think the links stay, but I am not sure... Just use trial and error. Hope this helps someone...

Gord Dibben · 08-03-2006, 08:20 PM

When you copy with this method, you just get a static picture.

If you want a linked picture use the Camera Tool found under
Tools>Customize>Commands>Tools

Drag that button to yopur Toolbar.

Select a range of cells and take a picture with Camera Tool.

Paste it and it will update as original data is changed.

Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 19:52:59 -0400, DCSwearingen
<[email protected]> wrote:

>
>I know this is an old post, but I see there have been 15 views so some
>people must be interested.
>
>I found a different solution, but...
>
>I stumbled on how to paste a picture on one of the MVP sites, I believe
>it was Jon Peltier's site?
>
>Simply hold the Shift key click on Edit, and some new features are
>present, including Copy Picture and Paste Picture.
>
>I don't think the links stay, but I am not sure... Just use trial and
>error. Hope this helps someone...

Gord Dibben · 08-03-2006, 08:40 PM

Yopur?

Is that a province in Pakistan?

Gord

On Thu, 03 Aug 2006 17:12:39 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>When you copy with this method, you just get a static picture.
>
>If you want a linked picture use the Camera Tool found under
>Tools>Customize>Commands>Tools
>
>Drag that button to yopur Toolbar.
>
>Select a range of cells and take a picture with Camera Tool.
>
>Paste it and it will update as original data is changed.
>
>
>Gord Dibben MS Excel MVP
>
>On Thu, 3 Aug 2006 19:52:59 -0400, DCSwearingen
><[email protected]> wrote:
>
>>
>>I know this is an old post, but I see there have been 15 views so some
>>people must be interested.
>>
>>I found a different solution, but...
>>
>>I stumbled on how to paste a picture on one of the MVP sites, I believe
>>it was Jon Peltier's site?
>>
>>Simply hold the Shift key click on Edit, and some new features are
>>present, including Copy Picture and Paste Picture.
>>
>>I don't think the links stay, but I am not sure... Just use trial and
>>error. Hope this helps someone...

Gord Dibben MS Excel MVP

**DCSwearingen** · 08-03-2006, 08:43 PM

This will definitely make Word reports smaller as well as PowerPoint presentaions.

**DCSwearingen** · 08-03-2006, 08:50 PM

I just had shoulder replacement surgery and have a tough time typing with two hands, much less with one.

Wish the forums all had spell check...

Just had to reply to yopur tpyo...

Originally Posted by Gord Dibben

Yopur?

Is that a province in Pakistan?

Gord

On Thu, 03 Aug 2006 17:12:39 -0700, Gord Dibben <gorddibbATshawDOTca> wrote:

>When you copy with this method, you just get a static picture.
>
>If you want a linked picture use the Camera Tool found under
>Tools>Customize>Commands>Tools
>
>Drag that button to yopur Toolbar.
>
>Select a range of cells and take a picture with Camera Tool.
>
>Paste it and it will update as original data is changed.
>
>
>Gord Dibben MS Excel MVP
>
>On Thu, 3 Aug 2006 19:52:59 -0400, DCSwearingen
><[email protected]> wrote:
>
>>
>>I know this is an old post, but I see there have been 15 views so some
>>people must be interested.
>>
>>I found a different solution, but...
>>
>>I stumbled on how to paste a picture on one of the MVP sites, I believe
>>it was Jon Peltier's site?
>>
>>Simply hold the Shift key click on Edit, and some new features are
>>present, including Copy Picture and Paste Picture.
>>
>>I don't think the links stay, but I am not sure... Just use trial and
>>error. Hope this helps someone...

Gord Dibben MS Excel MVP

Gord Dibben · 08-03-2006, 09:10 PM

My Agent News Reader has Spellcheck but I can pick up mistakes visually so have
no need of it<vbg>

Gord

On Thu, 3 Aug 2006 20:50:31 -0400, DCSwearingen
<[email protected]> wrote:

>
>I just had shoulder replacement surgery and have a tough time typing
>with two hands, much less with one.
>
>Wish the forums all had spell check...
>
>Just had to reply to yopur tpyo...

>
>
>Gord Dibben Wrote:
>> Yopur?
>>
>> Is that a province in Pakistan?
>>
>>
>> Gord
>>
>> On Thu, 03 Aug 2006 17:12:39 -0700, Gord Dibben <gorddibbATshawDOTca>
>> wrote:
>>
>> >When you copy with this method, you just get a static picture.
>> >
>> >If you want a linked picture use the Camera Tool found under
>> >Tools>Customize>Commands>Tools
>> >
>> >Drag that button to yopur Toolbar.
>> >
>> >Select a range of cells and take a picture with Camera Tool.
>> >
>> >Paste it and it will update as original data is changed.
>> >
>> >
>> >Gord Dibben MS Excel MVP
>> >
>> >On Thu, 3 Aug 2006 19:52:59 -0400, DCSwearingen
>> ><[email protected]> wrote:
>> >
>> >>
>> >>I know this is an old post, but I see there have been 15 views so
>> some
>> >>people must be interested.
>> >>
>> >>I found a different solution, but...
>> >>
>> >>I stumbled on how to paste a picture on one of the MVP sites, I
>> believe
>> >>it was Jon Peltier's site?
>> >>
>> >>Simply hold the Shift key click on Edit, and some new features are
>> >>present, including Copy Picture and Paste Picture.
>> >>
>> >>I don't think the links stay, but I am not sure... Just use trial
>> and
>> >>error. Hope this helps someone...
>>
>> Gord Dibben MS Excel MVP