Hi,

I have migrated recently to excel 2010 and I'm stuck with a weird thing
I have a report built with linked images, that direct to different sheets with pivot tables that may grow or decrease depending on the selection made

To avoid deleteing and copying again all the images I used to have linked images for a very large range on each sheet, and then I would hide all unused rows of the sheet

in 2003 that made the image become smaller, and everyting stayed in scale.

now that I open it in 2010 it is weird that two of the images continue working flawlessly, but a third one does not decrease and scales vertically whatever fows are left visible on source sheet to fit the shape size (wich is huge)

anyone out there with experience in linked images of ranges?

it is possible to specify what kind of behaviour is desired?

I tried recreating the image, linking it manually, but always the same behaviour

maybe there is a better way to do that in office 2010 and I just not know about -- please let me know if that's the case!

kind regards!