Camera Icon and picture updates automatical as information changes

[jjf113]

In excel 97 there was a camera icon. I would highlight a section on excel,
click on the ICON and paste the results in another section. When the original
section changed it would auto update the section I pasted too. Does this
feature exist in excel 2007? My goal is to have the image update on a chart I
created from another section of the workbook. I use to use the Camera icon
alot in excel 97. But can not find the same features in excel 2007

 

[Ron de Bruin]

See the first tip on my Print page
http://www.rondebruin.nl/print.htm

You can see how you can do it in Excel 2007

 

[Jim Thomlinson]

Check out this link under the General Weirdness category you will find the
Camera Tool...

http://spreadsheetpage.com/index.php/oddities/

 

[Bernard Liengme]

Right click on the Ribbon
Chose "Customize Ribbon"
Add the camera tool to the QAT
best wishes

 

[Gord Dibben]

Button>Excel Options>Customize>Choose commands from>All Commands.

Scroll down until you reach Camera

Add to QAT


Gord Dibben MS Excel MVP