Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table reorganizes when it shouldnt!
Hi!
I have a pivot table based on a range of part#s and amount in two columns on sheet1, I create the pivottable in sheet2 and in sheet3 I add information that I get on the parts. The list in sheet1 increases daily with a varying amount of part#s and corresponding stock amounts, some part#s which already exist but the pivot table correctly only keeps 1 instance of that part# and adds the new amount, which is ok since sheet3 then keeps its consistency, the pivot table is presently covering 200 rows in sheet1. The problem is, that at about 50 items on sheet1 the pivot table seems to decide to reorganize the data so that the commenst added to the part#s and amount in sheet3 no longer corresponds to each other! The questions are.... 1) Wtf does the pivot table suddenly decide to reorganize data!? 2) Is there a way to stop it from doing so? Any help appreciated...thx! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table reorganizes when it shouldnt!
Btw it is excel 2003 due to company policy or other lame excuse to show that
their it-department isnt up-to-date. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table reorganizes when it shouldnt!
Hi
When there are changes in the source data and a Pivot Table refresh is carried out, there can be new entries included in the revised table. If the data has been set to be Sorted ascending or Descending by some particular filed value, then the data will be adjusted to incorporate this. As such, if you are going to insert comments relating to rows in a PT, you cannot assume that the data upon which you are commenting will always be in that same row (or column) location. Rather than referring to a cell location, you should use the GetPivotData method to extract the data to sit alongside the comment you have made. For more information on GetPivotData, take a look at Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "MS" wrote in message ... Hi! I have a pivot table based on a range of part#s and amount in two columns on sheet1, I create the pivottable in sheet2 and in sheet3 I add information that I get on the parts. The list in sheet1 increases daily with a varying amount of part#s and corresponding stock amounts, some part#s which already exist but the pivot table correctly only keeps 1 instance of that part# and adds the new amount, which is ok since sheet3 then keeps its consistency, the pivot table is presently covering 200 rows in sheet1. The problem is, that at about 50 items on sheet1 the pivot table seems to decide to reorganize the data so that the commenst added to the part#s and amount in sheet3 no longer corresponds to each other! The questions are.... 1) Wtf does the pivot table suddenly decide to reorganize data!? 2) Is there a way to stop it from doing so? Any help appreciated...thx! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table reorganizes when it shouldnt!
Thx, Ill see if I can put that function¨to use in my sheet.
Btw the list of part#s and amount is appended to the already existing list on a daily basis and cleared once a week. There is no sorting option on the pivot table that I know of? And any input data isnt sorted either. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
excel shouldnt need a symbol before the first number in an equati | Excel Worksheet Functions |