Excel file is very slow and crashes repeatedly

baadams

Board Regular
Joined
Mar 2, 2006
Messages
130
This one has me stumped. We have a fairly simple Excel file around 2MB. When you open it, and view the task manager Excel is using 1.6GB of physical memory with only this one file open. What could be causing it to use so much computer memory. You can only navigate the file for a couple minutes before Excel warns you that you don't have enough memory. The more you navigate the file the more memory Excel starts using.

There are no data connections. It's an .xlsx file with no VBA. It has no external links. I can't find any hidden functions. I've tried deleting all of the functions I can find and it changes it very little.

I can hardly work in the file for more than a couple minutes before it becomes useless. The file acts like it's very large, but it's small in comparison to other files we use that function normally.

I can re-build the file, but my curiosity has gotten the best of me.

Thanks for the help.;)
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
1,918
Corrupted file...
You should open the xml descriptory files that are in the xlsx container: open the file.xlsx using 7Zip, or rename the file as .zip and open it via winzip or similar utilities; or you could try removing personal information and share the workbook for our investigation.
Bye

(don't miss Leandro's message, above)
 

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,492
Office Version
  1. 2010
Platform
  1. Windows
You could check that the usedrange on each sheet is set to something sensible, try running this macro on each sheet:
VBA Code:
Sub Uranger()
inarr = ActiveSheet.UsedRange.Address

MsgBox (inarr)

End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,113,939
Messages
5,545,110
Members
410,658
Latest member
kris_friis
Top