Excel Sort Query using images

Excel Sort Query using images

Didn't find your answer?

Looking to set up an excel price list with a column to include product images.Want to be able to sort the data by column headers e.g. stock number,category etc.However when I sort on these the image does not sort with the rest of the row data i.e. it stays where it is. Can anyone assist ?
David Peddie

Replies (1)

Please login or register to join the discussion.

avatar
By neileg
30th Sep 2003 09:25

Yes and no
Images are not contained in an Excel spreadsheet, but on it. Therefore, they are not recognised as data and the sort, or other manipulation wont work.

What you could do is hold a hyperlink in your spreadsheet that will pop up the image when clicked on. The hyperlink will be regarded as data and will be sorted correctly.

You could use Access to hold images directly but there are issues about the size of the resulting files if you embed the images rather than linking them

Thanks (0)