Pivot Table Dates

[Neil Thompson]

I'm bringing in data from an external database & creating a Pivot table with
grouped dates (Eg months)

when this table is copied and the date grouping changed from say months to
qtrs it changes the original to qtrs as well

is it possible to avoid this happening without creating seperate workbooks

Many thanks

Neil Thompson

 

[Ken Wright]

You can always create another Pivot table within the same workbook, but not
link it to the existing one, You will pay the price in terms of filesize,
but it will fix your problem.

 

[Ken Wright]

Just to clarify - use the same source data but when it prompts you and asks
if you want to link to an existing table just say no.