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,