Huge file - new suggestions please

[bryanj]

So I have looked through previous threads and tried suggestions but I can't seem to decrease the file size of my Excel 2007 document.

I have 4 tabs in one workbook. 2 tabs appear to have normal data ranges (based on the scroll bar size) and the other 2 tabs appear to be huge. In the one tab I've tried edit|go to special| last cell which is XFD1048573. From there I tried to delete the rows between the last cell and the last data cell but it simply gives me an error message "excel cannot complete task with available resources." I am only running one excel workbook (with the 4 tabs) and this browser window. I tried deleting a smaller range but the amount it will process seems like it will take me a few days to do it this way. Any other suggestions on how to decrease the file size?

 

[Greg Hitchon]

You could either delete them by hand in smaller blocks, get a macro to do this, or what may be easier is try clearing the contents of the unused rows instead and then try using Save As instead of save (you can save it to a different name or the same) and see if that helps. As far as I know Excel does some extra clean up when saving as vs save so give it a shot.