automatically update excel linked pictures/objects

Hi,

I have a series of pictures on an excel worksheet that reference tables/cells in another hidden worksheet. The data behind the pictures/tables are frequently updating and the pictures are only updating "sometimes". Is there a way to refresh the picture data automatically?

Sometimes I have to click the picture and press enter.

Any help is much appreciated.

bump

Any ideas?