I have been given a 40mb xlsb file. I noticed on a worksheet that it 1048576 rows of which only about 150 are being used. Also it goes out to column XFD. I haved cleared contents tried saving etc. If I try to delete a row or column I get an error not enough memory. I know that all these blank rows and columns are blowing up the file size. How do I get rid of them?

Any help would be greatly appreciated.