Go to excel preferences> Edit> Date options> Automatically convert date system. Also, Go to Tables & Filters> Group dates when filtering. The problem probably started when you received a file with a different date system, and that screwed up your excel date function. That is interesting that the other method does indeed work for the other data columns and simply not the 'Grand Total' column. Seems to be a bug in OS X Excel. Further, with an enormous dataset that becomes a hassle; actually this set is so long that it didn't cross my mind to move to the bottom and try this method. Summary: Like any other program, Microsoft Excel 2016 can also fail while opening to start or sometimes during the task. Consequently, error messages such as ‘Excel 2016 is not responding’ can pop up. Let’s say you worked on an important Excel document which is to be presented during a meeting the next day. Mac recovery disk. The Excel spreadsheet included critical graphs and charts, and more. While saving the document, there was a power failure due to which your system got shut down abruptly in the absence of power backup. After the power resumed, you restarted your system to check the Excel file. To your dismay, the ‘Microsoft Excel 2016 is not responding’ error popped up. ![]() Consequently, you were not allowed to access the Excel file. How do you tackle this situation? Read on to know a few solutions that can help recover from the error. ‘Microsoft Excel is not responding’ problem Despite its string of benefits, like any other program, it is not foolproof. Let us look at an instance. Suppose, you worked overnight on a very critical document which is to be presented at a meeting the next day. This Excel spreadsheet includes critical graphs and charts, and much more. When you are about to save it, there is a power failure, and your system shuts down without warning. When the power is up, you restarted your system to check your Excel. To your dismay, a message pops up – “Excel Crashed” or “Microsoft Excel not responding”. It may be frustrating, yet there is no need to despair as there are solutions to not only overcome this error but other corresponding errors such as freezing, hanging, etc. Solutions to fix the ‘Microsoft Excel 2016 is not responding’ error All the solutions described below have been found useful in one or the other case. Try them one by one. Solution 1: Open Excel in Safe Mode Opening Excel in Safe Mode is a common do-it-yourself and straightforward solution to fix ‘Excel 2016 is not responding’ problem. Excel can overcome some startup issues wherein another program or add-in crashes Excel. ![]() The steps to open Excel in Safe Mode are as follows: • Press Windows + R keys simultaneously to open the Run box • Type exe /safe. Figure: MS Excel in Safe Mode Solution 2: Change the ‘Default Printer’ Although it may seem irrelevant, changing the default printer is another easy and effective solution to overcome the error. Reason being, Excel communicates with the printer to find supported margins when we open an Excel sheet. If Excel doesn’t find the supported margin, it crashes. The steps to change the default printer are as follows: • Open Control Panel on your Windows system • Click Printer and Devices • Right-click Microsoft XPS Document Writer to set it to the default printer • Reopen the Excel document to check whether the error occurs or not. Figure: Change in Default Printer Setting Solution 3: Install the latest Windows and Office Updates This problem may also occur if Windows and Office Updates are not updated.
0 Comments
Leave a Reply. |