Solved

Excel document freezes.

Posted on 2016-09-07
5
31 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
5 Comments
 
LVL 16

Expert Comment

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

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 23

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to search 5 25
Excel Copy Macro down foe each row 4 20
CD-RW/DVD-ROM DRIVE 3 30
Need quick fix on defining a variable 5 15
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now