Excel files issue

Hi

I am having issue with Excell files. When I try to open few files which has a lot od data excel just freezes.

Any idea how could I investigate or how to fix it?

Operating system Windows 10
yodaaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
xtermieConnect With a Mentor Commented:
My Excel usually freezes when
a) there file is quite large
b) there are external references
c) lots of match and lookup functions using external references.
d) there is a problem with any add in(s) you may have installed

...or your machine does not have enough memory to process your file(s) and their required calculations.

Excel files can live a long time, being upgraded from version to version and travel from one user to another user. Many times the user that have inherited the file don't know what's included in the file.
Problems with Excel files crashing or hanging can be caused by several things most of the time it is narrowed down to formatting and calculations. The following is a list of possible resolutions.

Check here for more details
https://support.microsoft.com/en-us/kb/2735548 

and here
https://support.office.com/en-us/article/Excel-not-responding-hangs-freezes-or-stops-working-37E7D3C9-9E84-40BF-A805-4CA6853A1FF4

Hope this helps!
1
 
Roy CoxConnect With a Mentor Group Finance ManagerCommented:
Try saving them as .xlsb files.
0
 
CompProbSolvConnect With a Mentor Commented:
Try opening the same files on a different computer to see if this is related to the files themselves or to something with that specific computer.
0
 
xtermieCommented:
author never came back to check, all proposals are valid
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.