Excel file is very slow and crashes repeatedly

[baadams]

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.

 

[Leandroarb]

Hi!

Too many formulas being calculated?

 

[Anthony47]

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]

You could check that the usedrange on each sheet is set to something sensible, try running this macro on each sheet:

Sub Uranger()
inarr = ActiveSheet.UsedRange.Address

MsgBox (inarr)

End Sub