Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by pngpapa View Post
I have created a spreadsheet of book I am wanting to purchase and I am
putting photos I get off the web of the books into the spreadsheet. Before
I put them into the cell I convert them to a .jpg file using Irfanview.

When I get done inserting the photo I right click on the photo in the cell
and go to "Size and Properties" and go to the "Properties" tab and select the
"Move and size with cell" option and make sure the "Locked" box is also
checked. I then close out the dialogue box.

I save the Excel file (I have Excel 2007 and have saved it as a .xls and
..xlsx file) and close it out. When I save the file I get a "Compatibility
Checker" dialogue box that tells me that "some cells or styles in this
workbook contain formatting that is not supported by the selected file
format. These formats will be converted to the close format available.".
I've closed out this box and let the file be saved.

Within a short when I open the Excel file in either extension (.xls or
..xlsx) the photos disappear.

How do I correct this problem?
with the above the method, you are just inserting the picture into the layout of the cell and not into cell.

try below method: Add a Picture to an Excel Comment (check whether this works for you)

Right-click the cell which contains the comment.
Choose Show/Hide Comments, and clear any text from the comment.
Click on the border of the comment, to select it.
Choose Format|Comment
On the Colors and Lines tab, click the drop-down arrow for Color.
Click Fill Effects
On the picture tab, click Select Picture
Locate and select the picture
To keep the picture in proportion, add a check mark to Lock Picture Aspect Ratio
Click Insert, click OK, click OK

for video on you tube
http://www.youtube.com/watch?v=rdBpA...layer_embedded

all the best
__________________
Thanks
Bala
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to prevent short cuts from disappearing from tool tips? Dima Excel Discussion (Misc queries) 0 April 15th 09 08:02 AM
How to prevent short cuts from disappearing from tool tips? Dima Setting up and Configuration of Excel 0 April 15th 09 08:02 AM
Inserted photos disappearing on scrolling david Excel Discussion (Misc queries) 0 June 12th 07 08:40 PM
how do I prevent the mouse pointer disappearing ? Chris J. New Users to Excel 0 October 5th 06 11:48 AM
how to show different photos, base on different value of a cell? Howard Hsu Excel Worksheet Functions 2 January 25th 06 06:57 PM


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"