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

Hi SueJB,

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?


Try saving the file as a webpage, close the file and then open the web file
and save it as a normal Excel workbook.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Hi Jan

Unfortunately it only made a very minor difference - reduced from 2342 kb to
2335.

Thanks for your reply, though

"Jan Karel Pieterse" wrote:

Hi SueJB,

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?


Try saving the file as a webpage, close the file and then open the web file
and save it as a normal Excel workbook.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

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

PS. Forgot to add - if using the paste special method to rebuild a workbook
there might be problems with links and references. Re-reading your post it
seems you may have these.

A better approach might be to copy each sheet to a series of new workbooks
and examine the file size of each. If one of these looks larger than
expected, concentrate on rebuilding that sheet in the original workbook.

Regards,
Peter T

"Peter T" <peter_t@discussions wrote in message
...
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

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