Reducing Filesize of Workbooks
 

Hi there,

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

Thx in advance

Gerry

Reducing Filesize of Workbooks
 

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

gerhard nowak wrote:

Hi there,

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

Thx in advance

Gerry

--

Dave Peterson

Reducing Filesize of Workbooks
 

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.

"gerhard nowak" wrote:

Hi there,

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

Thx in advance

Gerry