Hello,

This dataset is NOT working as expected in one system but works in other. Not able to Group Date Field as it is greyed out

I have a Pivot table with Dates and trying to Group. PivotTable Analyze - Group Field is active but when I click on it Grouping Dialog Box Opens Up but

- Start / End Date option is greyed out ( and Number of Days also)
- All Entries are Valid Date
- When I select Group Field the active cell is in Date field only
- File - Option - Data - Disable Automatic Grouping is Unchecked
- File - Options - Advanced - Display Options for this Workbook - Group Dates in Auto Filter Menu is Checked.
- copied Date field in new workbook and tried same result, not working.

Any thoughts?

Thanks