Recent content by SunshineX

1: Do you ever alter the data in the pivottable itself? 2: do you do any drag and drop movements to sort the pivottable ? 3: Do you rename any fields or indeed any ITEMS in any fields ? Rgds, Geoff I have noticed that I cannot rename the "Houston2" in the pivot table itself. But I never alter...

It's an extensive multipage workbook that tracks an incoming feed from a SQL server, coverts the data multiple times to produces graphs and charts based on alot of other unrelated junk. The part that is bugging me about it, is just the simple pivot table is acting up. All I want is to have it...

It needs to be sorted in Alphabetical order because another worksheet reads this data and uses it as a lookup table. However the pivot table just reads this one column (Location) and shows a 'Master List' of Locations.

It's 'location' in the Row field, then I put Location in the space above that also, the 'Count of' box. That is so the table will smash down and be smaller only using 2 columns, it is not really needed. Nothing else in any other fields.

It needs to be sorted in Alphabetical Order Also sometimes new entries are added. Other than that it is just a straight list

Well, truthfully, It has a huge range selected, up to row 1233, and one of the entries in the pivot table is (blank) That way when I add data it still usees the same range. Re-selecting the range does not affect it, I am using the pivot table wizard.

I re-sorted the data that the table comes from and then refreshed the table. The wierd thing is, making the table again, with the same source data, eliminates the 2. Then later altering the data (I have to add more entries somtimes), it will choose one and 2 it !

No, its not the headings, this is actually just a straight list, named 'Locations' then in the list it says "Houston"...but after messing with it for a while it will say "Houston2", then it never goes back

A possible solution to this may be: Open any directory window. To goto the Tools menu, Folder Options, Then click the File Types tab. Look in the File Types list for the .xls extension and click Change, then click Advanced Choose to change the Open function the entries should look like this...

My pivot tables work great but sometimes when I update them the field data entries are appended with a '2' For instance a list of locations might contain the entry "Houston2" but the original data for that was just "Houston" After remaking the pivot table and putting the exact same setup for...