I have a workbook with about 30 worksheets in it. I share this workbooks
(and turn off track changes) and have several people enter data into these
sheets. Note that this data is not a lot of data.

The size of this workbook when I initially create it each week is 1.8 Meg.
After the first day, it grows to about 8 meg. By the end of the week, it
grows to about 16 meg.

Note also that, even though track changes is turned off, there are still
some changes that have been tracked - not a lot, but some.

Can anyone point me in a direction here? I need to keep the size of this
workbook to be less than 8 meg.

Thanks,
Mike.

Mike

Take a look at:
http://www.contextures.com/xlfaqApp.html#Unused

May not be what you need but it might help.

Mike Rogers


"Mike D." wrote:

I have a workbook with about 30 worksheets in it. I share this workbooks
(and turn off track changes) and have several people enter data into these
sheets. Note that this data is not a lot of data.

The size of this workbook when I initially create it each week is 1.8 Meg.
After the first day, it grows to about 8 meg. By the end of the week, it
grows to about 16 meg.

Note also that, even though track changes is turned off, there are still
some changes that have been tracked - not a lot, but some.

Can anyone point me in a direction here? I need to keep the size of this
workbook to be less than 8 meg.

Thanks,
Mike.