HELP!! Deleting empty rows (file size issue)

Hey Excel Experts,

Please help me out! The size of my excel sheet has suddenly increased in size from several KB's to over 6MB. I've read a whole lot about this problem and the various solutions but still no result.

My excel sheet is in fact a sort of 'app' based program. I do use a lot of different formulas, pivot tables and macro's. But the sheet is still empty i've only put in test data.

I think I already know what the problem is, in several tabs when I press "control+end" the selected cell is the last on the sheet XYF 1048576 or something. I know that this rapidly increases the file size. I've tried to delete EVERYTHING on several ways but still if i press cntrl+end it keeps going back there.

I also used the f5 option to finds all sorts of (hidden) formulas, objects etc bu still no result.
Also i've tried several macro's that where available online that are supposed to delete the empty cells but this didn't work either

Is there anyone who can help me out?

Thanks in advance

Nick's picture

 95. Excel Tips - Cause Of