If you’re seeing the “Cannot group that selection” error message when trying to group pivot tables, it is most likely because your data is invalid in some way. One of our customers sent us some example data that was causing this problem: If you look carefully you’ll see that one of...
I get the group option, but once I click it, it tells me 'cannot group that selection'","kudosSumWeight":0,"repliesCount":2,"postTime":"2019-05-07T04:06:45.767-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"...
On the Data tab, in the Data Tools group, click What If Analysis, and then click Scenario Manager. In the Scenarios box, locate the scenario that causes the compatibility issue, and then edit its reference. This workbook contains dates in a calendar format that is not supported...
G drive when installed on the desktop for windows 11. On making changes to excel files present in the drive and trying to save it. The drive throws an error as displayed in the attached image. "Microsoft Excel cannot access the file E:\Shared… ...
Hi all.I need your valuable help again and i am really excited for your solutions. I am taking an export data from a programme that has Work Breakdown...
ADDMENU/DELMENU Record Group Count MSODRAWING: Microsoft Office Drawing MSODRAWINGGROUP: Microsoft Office Drawing Group MSODRAWINGSELECTION: Microsoft Office Drawing Selection MTRSETTINGS: Multi-Threaded Calculation Settings MULBLANK: Multiple Blank Cells MULRK: Multiple RK Cells NAME: Defined Name NAMECMT...
This error occurs when the page you're attempting to modify becomes too complex forEdit in Excelto process effectively. The primary cause is the installation of multiple extensions that add fields with identical field names to the same parent page, leading to conflicts. It's also possible for ...
cannot save or export XML data. The XML maps in this workbook are not exportable. cell color change format to dates that will be expiring Cell Fill Colors Change When Copying Into New Sheet Change date format in ms excel 2013 form MM-DD-YYYY to DD-MM-YYYY Change Excel 2013 default date...
VBA Pivot Table Filter Between Two Dates VBA Runtime error: Microsoft Office Excel cannot access the file [path]\B6E79B00 on very simple code VBA Table Structured Reference - One Row Multiple Columns VBA to Change Power Pivot Connection String VBA to clear the Immediate Window VBA to connect...
The file is corrupt and cannot be opened. The error message occurs due to a setting in Excel. To fix the issue, do this: Open Excel 2010 Go toFile>Options. Go toTrust Center>Trust center settings. ClickProtected view. Then clear the check boxes for the first two options. ...