I have a pivot table on the spreadshhet which get data from my MS Access.

My query have the order by MyDateField.
It seems pivot table does not follow the order by rules.

It always adds new record at the end.

For example, I have data for Feb/12 and Feb/15. It always add Feb/15 before
Feb/12 even I change the order.

any ideas about this?

Your information is great appreciated,

Your description is a little thin. Check out this...
http://www.contextures.com/xlPivot04.html

Or assuming your date is an actual date you can sort the data in the pivot
by clicking on the date field and selecting Field Settings - Advanced -
Sort...

--
HTH...

Jim Thomlinson


"Souris" wrote:

I have a pivot table on the spreadshhet which get data from my MS Access.

My query have the order by MyDateField.
It seems pivot table does not follow the order by rules.

It always adds new record at the end.

For example, I have data for Feb/12 and Feb/15. It always add Feb/15 before
Feb/12 even I change the order.

any ideas about this?

Your information is great appreciated,