Reducing Filesize of Workbooks

[gerhard nowak]

Hi there,

Is there any simple method of reducing the filesize of a workbook?

Thx in advance

Gerry

 

[Dave Peterson]

Maybe...

If you hit ctrl-end and the active cell is way past what you think it should
be...

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

 

[Guest]

Delete unused VBA macros and modules.
I had a bunch of Excel worksheets, with the same macros, so I put all the
macros in a special file, where they could be maintained more easily, and
deleted the modules from the other files. I save at least 25K on each file.