Pivot table, Automatically puts data in alphabetical

**Cicada** · 07-29-2011, 12:31 PM

Hi all,

Very new to power pivot and pivot tables. I have a pivot table with a fairly large data set and it is automatically placing a field in alphabetical order, i do not want this. I would like it to appear in the source datas order. I have gone to sort and it is checked to appear in original order not sure why it is not working. i have gone to options by right clicking and when i go to display options where it says alphabetical or source data order, alphabetical order is checked and i can't change it. very annoying. Secondly could someone gove me a heads up on possible reasons why one whole column of data is not appearing. The column is available though there is no visible data it is just blanks. thanks for your help.

Regards
Dan

**Cicada** · 07-29-2011, 01:56 PM

I just noticed that the column that is showing no data, there is a background error showing in my source table. it is saying for every cell in that row Inconsistent Calculated Column Formula Error. What is this? and could this be the reason? also i am a little perplexed as I do not have formulas in these cells it was a copy paste of a filtered column in another sheet

Regards
Dan

**Cicada** · 07-29-2011, 02:29 PM

Figured out my problem with the data not appearing. Though there are many features disabled and i'm not sure why. as above when i go to revert back to data source order it is disabled i can't change it. when i go into field settings to summarize value firld by all the option are disabled. Something simple probably can someone help me out.

Regards
Dan

**Cicada** · 07-29-2011, 02:55 PM

ok fixed the summarize part still cant't figure out how to change the alphabet to original order

**Cicada** · 08-21-2011, 04:41 PM

Hi all I posted this some time ago and still can't figure it out. as mentioned previously the data is ticked to appear in Source data order though this is not the case at all. it is appearing in az ascending order which is not marked and i have no idea why this is occuring does anyone have any experience with this problem. any help would be greatly appreciated.

Regards
Dan

**Cicada** · 08-21-2011, 05:28 PM

I think the problem is coming from (pivot table) Options, when i click on that and go into display atthe bottom there is Field List this section is not illuminated and therefore i cannot change anything and here it is marked as alphabetical. does anyone know why i can't change this? I have read that OLAP sources cause this i don't even know what that means. The data comes from the net and i then arranged it in tables and copied that table to another workbook. then executued the pivot table. Lost

Regards
Dan

**Cicada** · 09-01-2011, 10:30 AM

hello all before closing this thread a solution for this for those who come across the same problem is to assign a number to each name this way they will appear in order.

Regards
Dan