Could be any number of issues.

How large are the jpegs you're using? How much RAM does your computer have?
What version of XL are you using? What's your processor speed?

Older versions of excel or computers with limited memory may not handle many
images well. If none of these questions are relevant (you have an up to date
computer with sufficient RAM and a recent version of XL) then you probably
need to debug your VBA code. If that's the case, it would help if you posted
the code that is giving you problems.

Dave
--
Brevity is the soul of wit.


"David" wrote:

I have been setting up a spreadsheet to use pictures in cells depending on
the value of a cell. I had a minor problem initially with the set up, but
thanks to JLatham we solved the problem. The trouble I am experiencing now
is that the VBA command appears to be jamming up. I have been using the
setup found at McGimpsey & Associates for "Looking up and displaying a
picture based on a cell value" for the cell formulas and the VBA. I have
expanded the sample found at McGimpsey from 4 pictures to 44 pictures. The
McGimpsey sample will show all pictures in one cell. I am spreading mine
over 44 cells. I have repeated the VBA command to reference the cells I want
the pictures to appear in. All has been working fine for the last ~30
pictures. Now I am suddenly running into a problem with the VBA command
Me.Pictures.Visible = False. I have been trying to enter picture ~30 and an
error message comes up asking me to "End" or "Debug". In addition to this,
the spreadsheet locks up. It does not seem to matter if I attempt to Debug
or End. Even when I try to close the spreadsheet it takes a long time. I
need to reboot my computer because Excel will jam even without a spreadsheet
open. I have to use the Task Manager to close Excel. Any ideas? Have I
exceeded a limit to the number of pictures that I can enter? Am I
overlooking a cell reference? Please let me know
David