- WHY IS EXCEL FREEZING UP WHEN I WANT TO GRAPH INSTALL
- WHY IS EXCEL FREEZING UP WHEN I WANT TO GRAPH UPDATE
To open the workbook for the first time, Excel has to recalculate the workbook and verify the values in the workbook. Opening an Excel workbook for the first time in a new version of Excel may take a long time if the workbook contains lots of calculations. If an Answer is helpful, please click "Accept Answer" and upvote it. Method 1: Open the workbook in the latest version of Excel.
WHY IS EXCEL FREEZING UP WHEN I WANT TO GRAPH UPDATE
Then, please refer to Reza-Ameri's reply, try to update Windows system and Office. Such as run Excel in Safe Mode, and open multiple workbooks to check this issue. Let's say I want to freeze row 100, so initially it does not even show on your sheet. Disabling this has no effect on the crashes. 2) Still crashes in Safe Mode 3) Only one COM add-in (MapPoint) enabled. These worksheets contain about 5 charts each. It's recomended to go to File > Options > Advanced to tick “ Disable hardware graphics acceleration” checkbox under the Display part,Īnd uncheck “ Ignore other applications that use Dynamic Data Exchange” under the General part to check this issue.īesides, there is an article, “ Excel not responding, hangs, freezes or stops working” you may refer to it. 1) Only crashes when on one of two worksheets. Such as the screenshot, there are 2 instances, and each instance has 1 workbook opended. All you need to do, in this case, is to minimize Excel and try to find, and later on, close the window. If Excel freezes, please go to Task Manager to check whether there are more than 1 Excel instances. Maybe it is just waiting for your confirmation to proceed, by you clicking on an OK button of a dialog window that might have appeared and is 'behind' the current Excel window. If you are running Windows 8, click Run in the Apps menu > type Excel /safe in the Run box, then click OK. When I click 'Enable Content' to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious 'Microsoft Excel has stopped working, Windows is checking for a solution to the problem' message. Do one of the following: If you are running Windows 10, choose Start > All apps > Windows System > Run > type Excel /safe in the Run box, then click OK. I've had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. How do you open these Excel files? Such as via opening files from Excel app or via double clicking Excel files. Try starting Excel without add-ins to see if the problem goes away.
WHY IS EXCEL FREEZING UP WHEN I WANT TO GRAPH INSTALL
You please tell me what's the architecture (32 bit or 64 bit) of your Office?įor the memory utilization, it's better to install Office 64-bit.