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
0
Utf
2/3/2010 4:52:05 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
579 Views

Similar Articles

[PageSpeed] 4

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" <jjf113@discussions.microsoft.com> wrote in message news:F310F16A-1B14-4841-88ED-A60FEBD55982@microsoft.com...
> 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
0
Ron
2/3/2010 4:55:30 PM
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
0
Utf
2/3/2010 5:03:01 PM
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" <jjf113@discussions.microsoft.com> wrote in message 
news:F310F16A-1B14-4841-88ED-A60FEBD55982@microsoft.com...
> 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 

0
Bernard
2/3/2010 5:59:35 PM
Button>Excel Options>Customize>Choose commands from>All 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 <jjf113@discussions.microsoft.com>
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

0
Gord
2/3/2010 6:24:01 PM
Reply:

Similar Artilces:

Preview information
I am wondering how I can change the company information that Excel defaults to when I choose to look at my documents via the Preview function. Thanks. To change the information in the footer, in Preview, click the Setup button On the Header/Footer tab, select one of the options from the Footer dropdown, or click the Custom Footer button. In the Custom Footer window, you can delete the existing data, and add options by typing text, or clicking the buttons (there are instructions in the Custom Footer window) When finished, click OK, click OK Marilyn wrote: > I am wondering how I can ...

Outlook Web Access: a picture in the signature
Hello, My name is Marko Schustek. We recently changed over to Exchange 2007. Our company chiefs use Outlook Web Access 2007. They usually have a signature with their telephone numbers and so on. They also have a small picture (logo), of the company, in their signature. How do we get this picture in the signature. At the moment there is only a red cross instead of the picture. The picture is in the jpeg format. Thank you for your help. Best wishes from Germany where is the image? it needs to be on a web server that is accessible from the internet. -- Diane Poremsky [MVP - Outlook] Nee...

Add address automatically
Hi all, Just wanna know if it is possible to include an email address automatically to the cc list whenever i wanna try to reply an email or create a new mail. I am working as a helpdesk thus whenever i want to reply to an it query i will cc the helpdesk account so that the rest of the helpdesk crew will know that the query has been dealt with. Thanks a zillion in advance. Not with any current version of Outlook. You can write code that does this: http://www.outlookcode.com/d/code/autoaddrecip.htm -- Russ Valentine [MVP-Outlook] "SecretCharacter" <henry.tan@tellabs.com> wro...

How to export icons in dlls.
Hi Gurus, I have extended the CTreeCtrl class and have some icon resources in it which are used as imagelist in tree. When i create a dll for it and use it in other applications it seems that icons are not getting exported and those images are not visible there. I have set the imagelist in the constructor of my class. Please suggest where i am missing....thanx in advance ...

Have you also Outllook client updating CRM contacts on synchronization ?
Hello, We discovered that each time an outlook client synch a contact, it changes some datas and update accordingly the corresponding CRM record. For exemple phone numbers an country code are changed. I would appreciate to know if this is special to our installation or if anybody else has this annoying effect ? Thanks CS TGhe Telephone input mask in Outlook is applied to the synched telephone fields in CRM. Not sure if you can modify the way Outlook formats contact phone numbers... "WT" wrote: > Hello, > We discovered that each time an outlook client synch a conta...

Update table in SQL replacing the existing value
Hello all, Well I am pretty novice on this... One of my customer use SQL for their primary Database. That Database is use for their ERP software, now they ask me to manipulate a table inside so, with that manipulation we should change value of this table. They use a script with an Excel spreadsheet see the following. SS-1164 Sp0001 145.23 Jane Doe EXEC ABCUUSERLEAVETIME 'SS-1164', 'Sp0001', 145.227419354839 Column A Column B Column C Column D Column E The script that they use ask them to copy the entire E col...

Updating 401k with M-2005
I've been trying to setup my 401k online with money, instead of manually having to type this all in every quarterly statement. I keep getting error messages that my password or username is invalid. I'm using the same exact password I would use to log on to the Web site, and it works via IE6, but within money it wont work. Anyone have any idea? In microsoft.public.money, Tony Lisanti wrote: > > > I've been trying to setup my 401k online with money, instead >of manually having to type this all in every quarterly statement. I >keep getting error messages tha...

changing sort order
I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is completely missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, the table is empty and its .err file is also blank. If the .err files do not show...

Outlook Desktop Icon #3
Recently my system just up and lost the default icon on the desktop for Outlook. Nothing I did deliberately and it's gone in all profiles. Outlook appears to still work fine and I can create a shortcut on the desktop, I have done that already. The problem is that the shortcut is just that, a shortcut. The original actually let me into the e-mail properties and such. It's more irritation value than anything and I really want to know what could have caused it and how to get it back like it was. I am running: XP Pro SP2 with all the updates and Office 2002 (10.6515.6735) SP3 with al...

PowerPoint security update KB982158
After the passle of updates from Microsoft the other day, there remains one that will not install. It reports installed, so I get no error code, but after a few minutes, it asks to be installed again. I had this happen before about a year ago, but I can't remember how I fixed it. Any help out there? -- retread: Just another senior getting re-capped Nevermind... just had a senior moment. I remember now.... I deselected AutoUpdate, shut down, restarted and then manually installed the update, then reset Autoupdate to ON. Seems to have solved the problem.... at least Auto...

How can I change to inches instead of pixels in Picture Manager?
I'm trying to size a huge pile of photos in MS Office Picture Manager, and I need to have the sizing in inches, not pixels. But I can't seem to find a way to change that setting. Is it possible, and if so, how and where? Thanks!!! "donnalee1966" <donnalee1966@discussions.microsoft.com> wrote in message news:3446B8A9-56D0-4F9A-88D0-8C743E7A2B7E@microsoft.com... > I'm trying to size a huge pile of photos in MS Office Picture Manager, and > I > need to have the sizing in inches, not pixels. But I can't seem to find a > way > to ...

real-time camera feed video on a GUI
Hi, I want to display real-time camera feed video on a MFC GUI. If so does anyone know of any webcam manufacturers who provides APIs to their camera product that would do this via USB for example or maybe I was think of a webcam with static IP which can be viewed with a browser and then displaying that browser image on the GUI. I welcome any suggestions. Thanks. You can use DirectX to do it. Take a look at this for some help http://www.codeproject.com/directx/LiveVideo.asp AliR. <ratcharit@gmail.com> wrote in message news:1140188342.013426.33690@z14g2000cwz.googlegroups.com... >...

How to automatically redirect Outlook 2003 users to an Exchange server
Hi everybody I've set up a new Exchange server 2003 and I want to configure the outlook clients to use it. But I don't want to do it manually on each computer by adding a new email profile using the Mail applet of the Control Panel. Is there a way to do it automatically using a script or something else? Can Office Ressource Kit help me? Before Exchange we were using Mdaemon. Now we need to change the configuration of Outlook. Thank in advance "Judica´┐Żl AHIVODJI" <judicael.ahivodji[@]ifrance.com> wrote in message news:u0dSQV0pFHA.3680@TK2MSFTNGP15.phx.gbl.....

Continuous update unsuccessful--this is truly bogus
Any updated info on the online account updating issues in Money 2005/2006. Example. I have several credit cards listed and setup for online account access, downloaded transactions (advanced register), etc. Suddenly the account will get an error stating that "update unsuccessful" and then never updates after that. I have read where the advice was to delete the online account and reset it up. The problems I have with that are that when I do that, now all my transaction history for that account is lost and I am given only the balance. I have selected the max for account hist...

Opening files automatically with Import Text File dialog box
I would like to eliminate the requirement to have a user click on the Import button during VBA control of the Import Text File dialog box. This will facilitate the automatic processing of sequentially numbered files. I would appreciate any suggestions. Here's a simplified listing of the code I'm using. Sub ImportOrigData() ' ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("OrigDataFile").Select Range("A10").Select Dim sText As String For DOY = 147 To 149 ' first and last day of year to be processed sText...

How do I change minus numbers to + numbers in a col in Excel?
Is there a way to highlight a column or a row and change all of the numbers from negative to positive or vice versa without doing the change cell by cell? Thanks "Paul L" <Paul L@discussions.microsoft.com> wrote in message news:74D3CE9E-0454-4AA5-89B8-3CA77BECA01B@microsoft.com... > Is there a way to highlight a column or a row and change all of the > numbers > from negative to positive or vice versa without doing the change cell by > cell? Thanks Put -1 in a spare cell, and Copy. Select the cells you want to change, then Paste Special/ Multiply -- David B...

Coloured pictures
I have a publisher 2000 document, consisting of 20 pages. If I insert a coloured image (.jpg or .gif) into a picture frame the resulting image only displays and prints as black & white. If I copyand paste the image into a new document, the resulting display is OK (i.e. coloured) I have checked all the options and settings for the file and cannot see anything wrong. Anybody got any ideas. Stuart Can you import the image directly into the document without the picture frame? -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com &q...

format/picture in email
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) just switched from pc to mac. <br><br>very frustrated when trying to embed pic in an email. <br> Outlook would allow edit/resize, text wrap or float and create a hyperlink hotspot over the image. Ent. doesn't seem to support any of that formatting fuctionality... <br><br>help anyone? > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3346677058_8293240 Content-type: text/plain; charset="U...

Boxes instead of pictures.
In some messages, I get boxes with another box and a red X in it, instead of pictures that were sent with the messages. What can be done about this? If you are sure the picture indeed got send; Are you using any anti-spam tool? -- Roady [MVP] www.sparnaaij.net Microsoft Office and Microsoft Office related News Also Outlook FAQ, How To's, Downloads and more... Tips of the month: -Create your own fully customized Toolbar -Creating a Classic View in Outlook 2003 Subscribe to the newsletter to receive news and tips & tricks in your mailbox! www.sparnaaij.net (I changed my reply add...

rules don't run automatically
I'm having problems with my rules lately because they aren't running automatically like they used to. Everytime it seems like I have to go to tools>rules wizard>run now... My rules are all the same: apply after message arrives with "something" in the subject move it to the "something" folder "ZenMasta" <me@nospam.kthx> wrote in message news:uAk9WlVuKHA.812@TK2MSFTNGP06.phx.gbl... > I'm having problems with my rules lately because they aren't running > automatically like they used to. > > Everytime it ...

Automatic filling of cells within a certain date range
Can someone please help, I have been stuck on this for the past two days... Column 'AB' has 'Start Date' and column 'AD' has 'Finish date' Row 19, cells 'AI' to 'DW' have the months written as 'J' 'F' 'M' 'A' etc.....from 2008 to 2015. I want to be able to enter a 'start date' in column 'AB' i.e. 1 January 2008 and a 'Finish date' in column 'AD' i.e. 1 April 2015. Then i would like the cells 'J - A' on row 19 to be filled with '1' in each month.... I...

Automatically load an "Add-In"
Excel template in VB for Math practice in school. The computers are networked. When the template workbook is opened, Excel does NOT remember that the "Add-Ins" have previously been added in Can anyone please suggest a line of code that I can put in the existing code that will automatically add in certain "Add-Ins" when the workbook is opened Thank Bill Hall I am not sure I understand the problem. Loading an add-ins has nothing to do with opening a workbook or template. Add-ins are loaded (or unloaded) through Tools | Add-Ins... -- Regards, Tushar Mehta, MS MVP --...

Need help with automatic date entry
In a sheet used as a data base, how do I have the current date updated or changed when the data changes in a record or row. I would like this to show when that record has been modified with out manually changing that cell. Hi Rightclick the sheet tab, choose "view code", paste this macro in: Private Sub Worksheet_Change(ByVal Target As Range) If Target(1).Column < 5 Then _ Cells(Target(1).Row, 5).Value = Now End Sub Replace 5 with whichever column number your dates are stored in. HTH. Best wishes Harald "Mike200575" <Mike200575@discussions.microsoft.com&g...

Excel graph as Value/picture
Hello, I would like to copy and paste an excel graph into aonther workbook without including the underlying data series. In other words, I would like the graph to exclude all formulas (similar to paste special> values when dealing with formulaes). -- Yunus Patel ------------------------------------------------------------------------ Yunus Patel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26579 View this thread: http://www.excelforum.com/showthread.php?threadid=514409 Hi, Select the chart and then whilst holding the SHIFT key use the menu Edit >...

FWD: Look at the security update
--mkfmqbped Content-Type: multipart/related; boundary="pztlqqku"; type="multipart/alternative" --pztlqqku Content-Type: multipart/alternative; boundary="uxlylohaloelt" --uxlylohaloelt Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Partner this is the latest version of security update, the "November 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to help maintain the security of your computer from these vulnerabil...