Hi Peter

I had only referred to the image as a property of a form (used as a splash
screen), and had subsequently removed the form and all references to it
within the code.

I was trying to avoid recreating the workbook as you suggested (although
that's a good idea) because it had 10 sheets, a lot of data and a number of
controls on each sheet.

However, more in hope than expectation I reset the final cell on the sheet
with the most data - and it worked - file size back to normal! No idea why
:-)

Thanks for your help - as ever, much appreciated
Sue

"Peter T" wrote:

Hi Sue,

Did you actually delete the image. Reason for asking is if you deleted the
the rows or columns the image was contained in, it will still exist. Try F5,
Special, Objects. If it does NOT report "No Objects found" press delete
(assuming of course you want to delete all objects).

I'm not optimistic that's the reason, or Jan Karel's suggestion would have
worked (I think). If you press Ctrl-End on each sheet, is the Last cell
where you expect it to be.

Failing the above, there may be a reason and fix, but it's probably quicker
to rebuild your workbook. When doing so, don't copy sheets. Select cells
(the little square that intersects row/col headers), copy and paste-special
formulas and then paste-special formats into new sheet(s) in a new workbook.

Regards,
Peter T


"SueJB" wrote in message
...
Hi all

I had a very large image included in a workbook that made the file too
large. I've deleted it, and all code that references it, but the file
hasn't
shrunk.

I'm assuming that Excel is storing the redundant data (probably as part of
autorecover actions?) but how do I get rid of it please?

All suggestions gratefully received - I need to use this across a network
and it's too big to be practical!

Sue JB