| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table dropping items from page item list
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table dropping items from page item list
What is the source data for the pivot table?
Sharon wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table dropping items from page item list
Hi 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? -- Sharon "Debra Dalgleish" wrote: What is the source data for the pivot table? Sharon wrote: 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table dropping items from page item list
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 http://support.microsoft.com/kb/322238/ Sharon wrote: Hi 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table dropping items from page item list
Debra Thanks for your help and interest. Will read the article - thanks again.
-- Sharon "Debra Dalgleish" wrote: 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 http://support.microsoft.com/kb/322238/ Sharon wrote: Hi 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? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| How do I set up filter for page fields in pivot table? | Excel Discussion (Misc queries) | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Item wise balance in Pivot Table | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
