I have a very large dataset, and several sheets contining pivot tables and charts.

When changig date sorting from "year" to "month" in one of the sheets, all te others are automaticly changing to te same.

How to avoid automaticly changing ??