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
gary_brown@ge_NOSPAM.com
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
> > gary_brown@ge_NOSPAM.com
> > 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,