Message:

<p>[QUOTE=&quot;calcol, post: 8461270, member: 77639&quot;]There is one other way to have pictures quickly available from the spreadsheet simply by clicking on a cell (not a true pop-up).&nbsp; The method is to put a link to a picture in a cell.&nbsp; Right click on an empty cell.&nbsp; Then from the menu, select “Link”.&nbsp; In the small and big boxes, go through the disk drive and folder structure to your picture.&nbsp; Click on it, and the complete path to it should be in the address box at the bottom of the window.&nbsp; Click on OK.&nbsp; The window will close, and the link will be in the cell.&nbsp; Double click on the cell, and the picture will now be displayed in your default image-viewing program.</p><p><br /></p><p>The advantage of the above method is that accessing pictures from the spreadsheet adds almost nothing to the file size of the spreadsheet because the pictures aren’t really in the spreadsheet.&nbsp; But there are two disadvantages.&nbsp; (1) As mentioned above, when you double click on the link cell, you are taken out of Excel and into an image-viewing program.&nbsp; This may not be bothersome to some folks.&nbsp; (2)&nbsp; Far worse; if you change the disk drive letter, rename any folders in the path, insert or remove folders in the path or change the picture file name, the link will no longer work.&nbsp; Or even worse, the link may bring up the wrong picture.&nbsp; And the spreadsheet will work on a different computer only if the images are there and have the same path as the original computer.</p><p><br /></p><p>Cal[/QUOTE]</p><p><br /></p>

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in