• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 63
  • Last Modified:

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
0
yodaa
Asked:
yodaa
  • 2
3 Solutions
 
Roy CoxGroup Finance ManagerCommented:
Try saving them as .xlsb files.
0
 
CompProbSolvCommented:
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:
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
 
xtermieCommented:
author never came back to check, all proposals are valid
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now