Hi,  I have several pivot tables in a workbook based upon the same data source.  Value columns are grouped by date ranges - eg. 30 day increments up to 120days.  Changing the grouping scheme on one tab changes it for all pivots based on the same data source - the source is a flat file, not a data connection, so I cannot simply create a new 'connection.   Segregating each sheet in its own workbook is a work-around but far from ideal.  The goal would be to have one sheet with 30-day buckets from 1-120, for example [1-30,...,90-120,>120], and another with some other scheme, eg 45-day buckets from 1-90 [=<45,45-90,>90].  Thanks for your help.

Excel 2010 with free PowerPivot Add-In.
Compatible with Office 2013 Pro Plus.
Group with Date Table entries.
http://www.mediafire.com/view/o4r6ofnn2zrfejz/01_30_15.xlsx