Solved

Excel document freezes.

Posted on 2016-09-07
5
37 Views
Last Modified: 2016-10-07
We have a user computer running Windows 10 with recent upgrade of Office 2013 from Office 2010.  

The user has to open up multiple Excel documents on that computer from the local C drive.  Those Excel documents were created in Office 2007 and 2010.  

Occassionally, when she was in the middle of working on one of the opened documents, the spreadsheet freezes.  She clicks on anywhere on the spreadsheet and it has no response.  She is however able to save her document - this is the only good thing.

To gain control again, the user has to click the Excel icon and close all documents.

If you have a clue, please advise.
0
Comment
Question by:nav2567
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 16

Expert Comment

by:FOX
ID: 41788549
have you pulled in the latest updates for office 2013?
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 41789188
Are they big files?

What RAM does the machine have?

Just thinking that the machine might be running out of resource
0
 

Author Comment

by:nav2567
ID: 41789305
everything was fine when he was using Excel 2010.  

I will check the file size.
0
 
LVL 24

Accepted Solution

by:
Brian B earned 500 total points
ID: 41791470
It could also be a corrupt document. Corruption can cause all sorts of random things to happen. Is it possible to narrow down which file(s) give her problems? If you can, there are a few things you can try, basically in my experience, the more work the solution is here, the better chance it has to fix the problem:
1. Save the file in a different format (I try to use SLK, but older Excel version sometimes works as well), close it and reopen it, save the file in the new format again.
2. Make a new workbook and copy the tabs from the bad book to the good one.
3. Make new worksheets in a new workbook and copy just the contents of the cells from the bad book to the new one.

One other idea I had is there might be some sort of conflict. Usually you can address it by running Excel in safe mode (Start, Run, "msexcel /safe").

Since you said the problem doesn't happen all the time, it may take some trial and error and sticking with the idea to know for sure if it actually fixed the problem.
0
 
LVL 14

Expert Comment

by:frankhelk
ID: 41833323
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Brian B (TBone2K) (https:#a41791470)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This story has been written with permission from the scammed victim, a valued client of mine – identity protected by request.
With the shift in today’s hiring climate (http://blog.experts-exchange.com/ee-blog/5-tips-on-succeeding-in-the-new-gig-economy/?cid=Blog_031816), many companies are choosing to hire freelancers to get projects completed efficiently and inexpensively…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question