How to assign data in the Inserted Picture.. Im using Excel-2007 and Im trying to display the calendar view (cell range a1:G6) in the in the picture view.by selecting the picture and typing '=Sheet1!$A$1:$G$6' in the formula bar. but its not displaying the value properly... it is displaying only one cell value (i.e. A1 value) instead of the particular given Range.. please help..
assign data in the Inserted picture.
- Thread starter Irshath
- Start date
It might be easier to select Sheet1!A1:G6, Copy, and then go to where you want the link and click on Home-Paste-As Picture-Psate Picture Link.
It seems that sometimes XL gets confused as to whether the formula you give should be a picture link, or just a text link.
It seems that sometimes XL gets confused as to whether the formula you give should be a picture link, or just a text link.