| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop a Pivot Table from Sorting my data (Excel 2007)
The data in my Access database is in the order that I want it to be
but my Pivot Table insists on sorting it either Ascending or Descending. I can't seem to turn this off... If I right-click on the field name and choose Sort More Sort Options... Manual (you can drag items to rearrange them) This makes no difference! If I choose PivotTable Options Display Field List: Sort in data source order This again makes no difference! Is there some trick I'm missing or is it simply impossible to preserve the original data source order? Br, Nick. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop a Pivot Table from Sorting my data (Excel 2007)
Excel 2007 PivotTable
Sort in data source order. With macro. Without Access database. http://c0718892.cdn.cloudfiles.racks.../04_26_10.xlsm Pdf preview: http://www.mediafire.com/file/hmtde2ymqjt/04_26_10.pdf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Count Values in Pivot Table (Excel 2007) | Excel Discussion (Misc queries) | |||
| How to stop pivot table crashing in Excel 2007 | Charts and Charting in Excel | |||
| Sorting Page Area Field Data in Excel 2007 Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot Table Sorting | Excel Discussion (Misc queries) | |||
| Excel 2007 pivot table data is truncated | Excel Discussion (Misc queries) | |||
Linear Mode
