software

Hi

I have a group of pivots, on on each sheet. The pivots have a page item.
They seem to arbitrarily drop items from the list, even though I know there
is data for the items. The next time I open the file, the missing item might
be back but another one would be missing. There are only 8 possible options,
so it can't be the number of items. I am wondering is this related to the
integrity problems being experienced with Excel 2003, even though I don't get
error messages and it doesn't trash the pivots?
--
Sharon

What is the source data for the pivot table?

Sharon wrote:
gt; Hi
gt;
gt; I have a group of pivots, on on each sheet. The pivots have a page item.
gt; They seem to arbitrarily drop items from the list, even though I know there
gt; is data for the items. The next time I open the file, the missing item might
gt; be back but another one would be missing. There are only 8 possible options,
gt; so it can't be the number of items. I am wondering is this related to the
gt; integrity problems being experienced with Excel 2003, even though I don't get
gt; error messages and it doesn't trash the pivots?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlHi Debra

The source is a query in an Access Database. I have checked the data in the
query and all of the items are there with data. If I recreate the table it
will work for a while but I think it may have something to do with the
AutoRecover?
--
Sharonquot;Debra Dalgleishquot; wrote:

gt; What is the source data for the pivot table?
gt;
gt; Sharon wrote:
gt; gt; Hi
gt; gt;
gt; gt; I have a group of pivots, on on each sheet. The pivots have a page item.
gt; gt; They seem to arbitrarily drop items from the list, even though I know there
gt; gt; is data for the items. The next time I open the file, the missing item might
gt; gt; be back but another one would be missing. There are only 8 possible options,
gt; gt; so it can't be the number of items. I am wondering is this related to the
gt; gt; integrity problems being experienced with Excel 2003, even though I don't get
gt; gt; error messages and it doesn't trash the pivots?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;

I haven't encountered a similar problem. Although it's targeted to Excel
2002, perhaps the suggestions in the following article will help:

XL2002: Pivot Table Fields Do Not Function After Excel Repairs and
Recovers File
support.microsoft.com/kb/322238/

Sharon wrote:
gt; Hi Debra
gt;
gt; The source is a query in an Access Database. I have checked the data in the
gt; query and all of the items are there with data. If I recreate the table it
gt; will work for a while but I think it may have something to do with the
gt; AutoRecover?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlDebra Thanks for your help and interest. Will read the article - thanks again.
--
Sharonquot;Debra Dalgleishquot; wrote:

gt; I haven't encountered a similar problem. Although it's targeted to Excel
gt; 2002, perhaps the suggestions in the following article will help:
gt;
gt; XL2002: Pivot Table Fields Do Not Function After Excel Repairs and
gt; Recovers File
gt; support.microsoft.com/kb/322238/
gt;
gt; Sharon wrote:
gt; gt; Hi Debra
gt; gt;
gt; gt; The source is a query in an Access Database. I have checked the data in the
gt; gt; query and all of the items are there with data. If I recreate the table it
gt; gt; will work for a while but I think it may have something to do with the
gt; gt; AutoRecover?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;