xls docs grew too big after inclusion of macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 25 Apr 2007 00:28 GMT

Hi,

I have an xls doc that I copy each year to start from again.
A long time ago I experimented with Macros but never used them but I managed
to grow the doc to a 16 MB file or something.
Even when empty (start of new year) the file is still that big. I now have
5 such files, it's starting to bug me :) , and I wonder if there's a way to
delete the macro overhead somehow that was linked into the file (at least I
think that's what happened). I looked for it but couldn't find it.

Reply to this Message

Dave Peterson - 25 Apr 2007 00:51 GMT

I don't think it's the macros that's increasing the size of your workbook.

But you can remove all the code and all the modules by following the
instructions from Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

Another thing you may want to try is hitting ctrl-End on each of the
worksheets. You'll be taken to what excel thinks is the last used cell of that
worksheet.

If it's way beyond what you think it should be, you can try the techniques from
this page on Debra's site:
http://www.contextures.com/xlfaqApp.html#Unused

Another thing that you may want to look for is pictures and/or other objects
that have been added to the workbook. That could cause an increase in file
size, too.

> Hi,
>
[quoted text clipped - 5 lines]
> delete the macro overhead somehow that was linked into the file (at least I
> think that's what happened). I looked for it but couldn't find it.

Signature

Dave Peterson

Reply to this Message

Peter - 25 Apr 2007 20:42 GMT

>I don't think it's the macros that's increasing the size of your workbook.
>
> But you can remove all the code and all the modules by following the
> instructions from Debra Dalgleish's site:
> http://contextures.com/xlfaqMac.html#NoMacros

Thanks !
It did indeed do nothing about the size, but at least the annoying Macro
warnings are gone.

> Another thing you may want to try is hitting ctrl-End on each of the
> worksheets. You'll be taken to what excel thinks is the last used cell of
> that
> worksheet.

Seems about right.
I'll just assume that the file-size is probably correct.
There are a number of pages, each 500 cells long and fairly wide as well.

> Another thing that you may want to look for is pictures and/or other
> objects
> that have been added to the workbook. That could cause an increase in
> file
> size, too.

Nothing of that.

Reply to this Message

Rate this thread: