Right-click on the pivot table and select Table Options.
In the Data options section, if the 'Save data with table layout' is
checked, you're saving your information twice (once in the original worksheet
and once 'invisibly' in the worksheet the pivot table is on).
I would suggest unchecking both the 'Save data with table layout' checkbox
and the 'Enable drilldown' checkbox.

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:

> How can I do a correct diagnostic analisys as to be certain that is so? for I
> see lots of chances they are.
>
> If the are the problem.... how can it be solved?
>
> "Gary L Brown" wrote:
>
> > 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,