Camera Icon and picture updates automatical as information changes
 

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

Camera Icon and picture updates automatical as information changes
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jjf113" wrote in message ...
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

Camera Icon and picture updates automatical as information changes
 

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

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

--
HTH...

Jim Thomlinson


"jjf113" wrote:

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

Camera Icon and picture updates automatical as information changes
 

Right click on the Ribbon
Chose "Customize Ribbon"
Add the camera tool to the QAT
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"jjf113" wrote in message
...
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

Camera Icon and picture updates automatical as information changes
 

ButtonExcel OptionsCustomizeChoose commands fromAll Commands.

Scroll down until you reach Camera

Add to QAT


Gord Dibben MS Excel MVP



On Wed, 3 Feb 2010 08:52:05 -0800, jjf113
wrote:

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