Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
sorting data on protected worksheet Sue Excel Discussion (Misc queries) 20 November 7th 06 07:31 PM
Creating a Custom Excel Function to Calculate Gini Coefficients [email protected] Excel Worksheet Functions 3 February 21st 06 10:15 PM
How do I turn off the Auto Date function in Excel Tim Excel Worksheet Functions 1 February 15th 06 03:20 PM
how do I set up a excel spreadsheet to auto sort data in order jason Excel Discussion (Misc queries) 0 January 3rd 06 07:17 PM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"