Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I turn off the auto sort function in excel
I have a pivot table and I have added new data to the data area. When I click
refresh the new data will not added to existing data rols on the pivot but rather as a new number. For example of I have data showing sales in December and I input new line items in the data source. I update my data source parameters and hit refresh. When I do this two decembers are created. One with the data already present and another with the new data. Why does it not add all together and create one december? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
How do I turn off the Auto Date function in Excel | Excel Worksheet Functions | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) |