File too big - Causes excel to not respond for several minutes.

[DPChristman]

I know I have posted this before, but I can't find the solution.

I am working with a pretty big spreadsheet (25 columns by 1,241). Not massive, but still...

The problem is when ever I try to make changes and save, the screen freezes. The spreadsheet weighs in at about 9 MB!

Doing a <ctrl> + end, the end point is AA18362 (well beyond the last filled or blank cell).

I have tried deleting the extra rows and columns, using clear content, etc. (all the usual steps), with no luck.

Any suggestions?

Thanks in advance

 

[Candyman8019]

Assuming you've tried 'Clear All' on rows 1242-18362? and tried deleting those rows as well?

Regardless I found this on another site...it is stated that this resets the used range, although I haven't tested it. Run this code and see if it makes a difference.

Sub ResetUsedRange()
  ActiveSheet.UsedRange
End Sub

 

[Joe4]

I know I have posted this before, but I can't find the solution.

A post of your old posts found this: Erasing Cells