What kind of a 'dynamic table' do you have? If it's a pivot table, it is
probably saving your information a second time.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Martinj" wrote:

Hi Gary,
Nor did it work, nor does it explain why it trippled its own size.
Any idea what may cause this? Any other idea how to repair it?
Thanks

"Gary L Brown" wrote:

My suggestion would be to save your worksheets to a new workbook.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Martinj" wrote:

Dear Sir,
I am working with an Excel file which has several pages, dynamic tables,
macros, and build in formulas. My excel was 3 MB size las week. Suddenly,
without any aparent reason the file shows 9 MB size. In the meanwhile I only
added a small dynamic table which is no real explanation for the increase in
size.

I assume something inside got broken.

Is there any maintenence program or procedure I could run over my file as to
fix whatever went wrong?

Thanks in advance,