Pictures wouldn't sort with its associated data

xinvux · Post by **xinvux** » 05 Jan 2011, 21:57

I am using Excel 2010 and I have a worksheet with several columns (item#, item picture, item title). I am trying to sort these data by item # in descending order, everything sorted the way it should be EXCEPT the pictures. They DID NOT move at all. For example: the picture that was originally in cell B2 stayed in B2 even though its associated data moved to another row, the picture that was originally in cell B3 stayed in B3, etc. I made sure every picture fits inside its cell and no edge touches the border.

I have attached a sample workbook.

Can anyone help me with this?

P.S.
I tried it on my other machine that has Office 2007 installed and everything sorted correctly but when I try to do it again in Excel 2010, the pictures did not move at all.

Post by **HansV** » 05 Jan 2011, 22:05

Hi xinvux,

Welcome to Eileen's Lounge!

I can confirm that the images sort correctly with the data in Excel 2007. I hope that someone with Excel 2010 will look at your sample workbook and have a suggestion.

Post by **StuartR** » 05 Jan 2011, 22:21

HansV wrote: ...
I can confirm that the images sort correctly with the data in Excel 2007...

Welcome from me too.

I can confirm that the images sort correctly with the data in Excel 2010, version 14.0.5128.5000 (32 bit).

Can you try starting Excel in safe mode and see if it works then (Just click the start button and type "excel /a" and then enter)

xinvux · Post by **xinvux** » 05 Jan 2011, 22:27

Nope, it did not work in Safe Mode either.

Post by **StuartR** » 05 Jan 2011, 23:02

xinvux wrote:Nope, it did not work in Safe Mode either.

Strange.

Do you have the same version of Excel as I posted above (File > Help > Look on the right side of the screen)

xinvux · Post by **xinvux** » 05 Jan 2011, 23:56

I have version 14.0.4734.1000 (32-bit). I am guessing mine is an earlier version and that might be the cause of pictures not sorting correctly?

Post by **HansV** » 06 Jan 2011, 00:12

I doubt it, but it won't hurt to see if there are updates for Excel (Start > All Programs > Windows Update > Search for updates).

Post by **Jan Karel Pieterse** » 06 Jan 2011, 05:22

What did you select EXACTLY prior to doing the sort?

xinvux · Post by **xinvux** » 06 Jan 2011, 16:04

I tried selecting the whole range of data and sort, and i also tried selecting just the Item # on the top and sort. Both methods did not work on the pictures.

xinvux · Post by **xinvux** » 06 Jan 2011, 17:14

Okay, I think I solved the problem!! I got desperate and I uninstalled and installed it and now it's working!! Thanks for everyone's help!!

Post by **HansV** » 06 Jan 2011, 17:17

Well, that was going to be the last-ditch suggestion. I'm glad it worked out well!

Eileen's Lounge

Pictures wouldn't sort with its associated data

Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data

Re: Pictures wouldn't sort with its associated data