Using Excel 2013, I have pivots and charts created from two data tabs in the same xlsx worksheet. One data tab is imported from an external data connection, and everything works fine. The other data tab contains data I've copy/pasted. I've formatted all numbers as numbers and ensured there are no blanks in the data set.
An example of what I want to group is a column containing values from, say 200-1000. I'd like to create groups for the slicer of 200-399, 400-599, 600-799, and 800-999. This works perfectly fine for one set of pivots (the set linked to the external data), but the "Group" options are greyed out for the pivots for the copy/pasted data. The nature of the data in both tabs is essentially identical (the one that's not working simply contains a few additional columns).
Thanks for your time,
Geoff
Bookmarks