excel for mac cannot group this selection

#EXCEL FOR MAC CANNOT GROUP THIS SELECTION HOW TO#

This video shows how to group Text items in a pivot table. This short video shows the basics of pivot table grouping Go to the How to Group Pivot Table Data page on my Contextures website. Learn more about pivot table grouping, and get a workbook with sample file that you can use for testing. If your pivot table is the traditional type (not in the data model), grouping problems are usually caused by invalid data in the field that you’re trying to group.įor solutions to grouping error in Normal Pivot Tables, see the Pivot Table Grouping page on my Contextures website. NOTE: There’s no option or setting that lets you change the pivot table from an OLAP-based source (data model), to a data source that isn’t in the data model. Keep the OLAP-based pivot table too, and you’ll have two pivot tables based on the same data, using different pivot caches.

Do NOT check the box to add the data to the Data Model.

Create a second pivot table from the source data.

If you want grouping, you’ll need a pivot table with its source data NOT added to the data model. Unfortunately, there’s no fix for grouping in an OLAP-based pivot table. Other features are unavailable too.įor example, you can’t create a calculated field or calculated item.

It’s not just grouping that is prevented In OLAP-based pivot tables. I have de-selected and re-selected Analysis ToolPak several times but the Analyze group is. If the command is active, your pivot table is OLAP-based In the Manage box, select Excel Add-ins and then click Go.If it’s dimmed out, your pivot table is the traditional type.In the Calculations section, find the OLAP Tools command.On the Excel Ribbon, click the Analyze tab (under PivotTable Tools).In OLAP-based pivot tables, the grouping feature is not available.Ī quick way to tell if your pivot table is OLAP-based is to check the Ribbon: If you added the source data to the data model, you created an OLAP-based Power Pivot, instead of a traditional (normal) pivot table. If you checked that box, you won’t be able to group any items in the pivot table.When you create a pivot table, there’s a check box to “Add this data to the Data Model”.But if you’re using Excel 2013 or later, there’s a new reason for the error message, that might affect you. You can run into pivot table grouping problems in any version of Excel. Excel leaves it up to you to find out what the problem is. As you can see, the error message doesn’t tell you WHY you can’t group the items. Here’s a screen shot of the pivot table error, “Cannot group that selection.” that appears. If you’re using Excel 2013 or later, there’s another reason that might prevent you from grouping pivot table items. Always have the latest Office apps, features, and services.When you try to group dates in an Excel pivot table, or other pivot table items, you might get a pivot table error, “Cannot group that selection.” In Excel 2010, and earlier versions, that error was usually caused by blank cells in your source data, or text in the number or date columns.

Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the. To copy rows or columns, on the Home tab, in the Clipboard group, click Copy. Press the Down arrow key until you reach the Edit in Excel Online option, and then press Enter to select it. To move rows or columns, on the Home tab, in the Clipboard group, click Cut. It sounds like it might be helpful to connect you to one of our Office support agents. Excel will be retired in Get the most up-to-date version of Excel and master your data. Extend the selection to the last nonblank cell in the same column or row as the active cell. If you purchase an auto-renew subscription, your subscription starts when you complete your purchase.

You can follow the question or vote as helpful, but you cannot reply to this thread. For example, Office Excel 2010 mac the Home tab, the Number group includes the Number Format option. You can Office Excel 2010 mac sharing your subscription with someone or remove Buy cheap Navisworks Simulate 2017 device they are using at If you have a Offics Office Excel 2010 mac questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. Easily predict trends by creating forecasts in one step.

Excel for mac cannot group this selection