Deleting Rows

[Petman]

For some reason, a 200kb file that I've been using (Excel 2007) has suddenly ballooned in size to over 6mb. Upon opening, I found that all 1,048,576 rows were active in the file. It only needs to be about 190 rows.

This should be a simple enough problem - highlight from 191 to the bottom, delete rows, close and save file... Should be fine upon reopening. But for some reason, it is not working. Every time I reopen the file and hit END-HOME, it goes to the last active cell FD1048576. (The column reference is correct!)

What's that they say about insanity is doing the same thing over & over and expecting different results?

Any suggestions?

Thanks,

Peter

 

[Jeff Meyers]

A suggestion to try: Copy all of your data (i.e. rows 1 thru 190), paste that to a new worksheet, and then save that new file.

 

[Petman]

Thanks for the suggestion.

Because of the named ranges and multitudes of formulas that run from the particular sheet in question, we opted to go back into the network archives and recover the file from a few days prior instead of using your suggestion.

After doing this, we discovered the root of the problem: A macro used a filter to find all instances of a certain condition, then copied a range using "xldown". When there were no rows that met the criteria, it copy / pasted a million+ rows. I fixed the macro to ensure it never happens again.

We didn't answer the original question of why I couldn't delete the million+ "active" rows. But since the problem is fixed, I'm not going to lose any sleep over it!

Thanks for your input...