Pivot calcultation

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 ??

Mark your TP (copied based on the same cash), cut it (create a new spreadsheet) and copy it to the new worksheet. Then the newly created TP copy (not cut) to your file and you're done. New sheet can be removed. Finished. Next to the new PT, you can do an independent grouping

Step 1: Launch Excel Application and click the Formulas menu.
Step 2: Navigate to the Calculation section and click on the Calculation Options.
Step 3: Select Manual from the Calculation Options drop down list.