xls docs grew too big after inclusion of macro

[Peter]

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.

 

[Dave Peterson]

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.

 

[Peter]

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.