Excel not responding, hangs, freezes or stops working
※ Download: Why does my excel keep freezing
One of our users is plagued with Excel crashes. And still the issues persist. This is a very rare and almost all the time the task is still being done and will be completed in a few minutes.
My laptop us less than a year old. But system administration has never been one of my talents. Are you working with any macros?
Microsoft Excel: Taking the Pain Out of Freezing Panes - My apologies to the moderator.
You MUST have a valid e-mail address so that you may receive the instructions to complete the reset. You may have to before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. So I'm encountering a weird Excel problem that I've never seen before... I have a macro-enabled workbook with about 12 worksheets, each with ~100 rows and 30 columns. The current worksheet I've been editing has frozen my computer a bajillion times - when I change the font, insert a row, delete a row, or do anything that affects multiple cells. Are these things related? Why is my worksheet suddenly so huge?? I didn't knowingly change any of this, so I'm a little lost on how to fix it. The file is also now almost 32,000 KB - a LOT bigger than a normal file. Press CTRL + End and see where the last active cell is!! Do that with each sheet. A Please and Thank You cost nothing! It's easier to debug if we can see the whole macro! I shut down Outlook and the other 4 copies running and when Outlook 2007 is not running my Excel runs flawlessly. So now I have to shut down Outlook to use my Excel. This is a new problem within the last 90 days or so because I have never had this problem before. Resources saved on this page: MySQL 12. Feedback Buttons provided by - Copyright © 2018 DragonByte Technologies Ltd. User Alert System provided by - Copyright © 2018 DragonByte Technologies Ltd. Redirecting Of Banned Users provided by - Copyright © 2018 DragonByte Technologies Ltd. All contents Copyright 1998-2018 by MrExcel Publishing.
Have you done a memory test. I didn't knowingly change any of this, so I'm a little lost on how to fix it. On further scrolling down i should still see both row 1 and row 100 freezed. Do you have any add-ins enabled. Hi I have discovered that excel 2013 has a serious memory management issue. Tried your option 3 to run as Admin and that worked. As you scroll to the right or down, the frozen columns or rows remain in place so that you can always view worksheet headings or the initial columns. At least that is a move in the right direction. It's been several Hours since the Graphics Driver Update 5 and half Hours as of this post and the user hasn't reported any more issues, too soon to save definitively if this has solved it, but signs are hopeful, if their is any further developments I will post any more findings.