Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    images (excel97)

    I have an excel file that stores an image of each style of garment that we are producing for the current season. A number of staff access this file to get a copy of the image to put into other excel files.

    There are approximately 250 styles, each belonging to one of three labels.

    In Column C is a Style number that is prefixed with a letter to show which label the garment belongs to. The Prefix is equal to the first letter of the name of the label. So if we had a label called ACME, the style number would be prefixed with an

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: images (excel97)

    The first thing I would try is to clean up ypur temp folder.

    Close all open applications.
    Click Start, run and enter:
    %temp%
    and hit OK

    Now remove all files in that folder.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: images (excel97)

    You say that the images have been pasted using Edit | Paste Special... > Picture. There is usually no Paste Link option when you do this, so the picture shouldn't be linked. You can check this, however by looking at Edit | Links...
    If the picture has become corrupt in all workbooks, there may be something else behind this. What happens if another user opens the workbook?

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: images (excel97)

    Thank you Jan and Hans for your responses.

    I have deleted a large number of the files in the temp folder, and the images have returned. The temp folder is located on my C: drive which is very very full only about 5MB was left before I emptied the recycling bin and the temp folder.

    The excel files themselves are stored on a separate drive.

    I couldn't get into Edit>Links, this option wasn't available, so guess there are no links.
    Other users aren't experiencing the problem any more as it appears to be fixed. I have opened it on a few other PCs and all is well. But I did not check them when I had the problem.

    Thank you very much. I was so happy to get this code to work in the first place and then wasn't very happy when I thought I wouldn't be able to use it. Big smile back on my face.
    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    Thank you so much for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •