Excel keeps freezing...perhaps due to an unusually large worksheet?

[raeannb]

Hi! So I'm encountering a weird Excel problem that I've never seen before...I have a macro-enabled workbook with about 12 worksheets, each with ~100 rows and 30 columns. The current worksheet I've been editing has frozen my computer a bajillion times - when I change the font, insert a row, delete a row, or do anything that affects multiple cells. It's frustrating! I've also noticed that when I use press End + Down Arrow at the bottom of my table, the worksheet goes all the way to Row 1048576 and End + Right Arrow goes to Column XFD - wayyyy more rows/columns than the standard 65536 and IV. Are these things related? Why is my worksheet suddenly so huge?? I didn't knowingly change any of this, so I'm a little lost on how to fix it. The file is also now almost 32,000 KB - a LOT bigger than a normal file. I'm puzzled. Help?!

 

[Derek Brown]

You did not say which version of Excel is being used.
However, Microsoft may have the asnwer:
http://support.microsoft.com/kb/244435

 

[Michael M]

Press CTRL + End and see where the last active cell is !!
If it's a long way down / across
try
got the the last row plus 1
select the row header and press CTRL+ SHIFT + down arrow
Now right click on any row header and select delete

Do the same with the last plus 1 column CTRL + SHIFT Right arrow
Right click a column header and select delete.
Do that with each sheet.
Save and close ...then reopen and see if it has shrunk the file

 

[Legacy 208406]

I was having freezing problems with Excel 2007 every time I tried to save, or copy cells. I shut down Outlook (and the other 4 copies running) and when Outlook 2007 is not running my Excel runs flawlessly.
So now I have to shut down Outlook to use my Excel. This is a new problem (within the last 90 days or so) because I have never had this problem before.