assigning a formula to a picture - Excel 2007

R

Robert Flanagan

In Excel 97-2003, one could copy a range as a picture, paste it on another
sheet, select the picture, and then type = and select the original range,
thus linking the picture back to the original range. Any change one then
did to the original range then appears in the picture.

I just tried to do this in Excel 2007 and could not do so. Is this a
feature that has been removed? If not, how do you do it?! Thanks for any
help.

Bob Flanagan
 
R

Robert Flanagan

Hi Ron. Thanks for the solution! I didn't realize they had added it as a
feature!

Bob
 
S

Shane Devenshire

Hi,

I find it is often easier in 2003 or 2007 to add the Camera tool to the
toolbar or QAT. Then select a range click it and click the target cell and
the picture is pasted with a link.

In 2003 the Camera tool can be found by choosing Tools, Customize, Commands
tab, Tools category...
In 2007 choose Office Button, Excel Options, Customize, and from the top
left drop down pick Commands Not in the Ribbon, ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Excel 2007 - Paste picture link does not print 2
attaching a picture to a cell. 2
Macro for transferring data from excel to word 1
Copy chart and paste it as a PICTURE back into Excel 3
Inner Borders in Excel 2007 2
Macro to insert picture from specific folder 0
Picture not visible in excel 2000 1

Top