View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Redundant data increasing file size?

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