Excel file is very slow and crashes repeatedly

baadams

Board Regular
Joined
Mar 2, 2006
Messages
134
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.;)
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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)
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top