View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default Empty Excel File that is 1.7 MB

did you save the workbook and recheck with Ctrl+End to make sure
the last cell is still where you think you changed it to. An easier way
than manually deleting rows and columns would be to run the macro
at:
Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish
http://www.contextures.com/xlfaqApp.html#Unused

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"octobert" wrote in message
...

Hi,
I have an Excel file that scrolls slowly and is 1.7 MB big when it
really shouldn't be. Change tracking is of, there are no formulas and
no VBA code. I have stripped everything out of the spreadsheet,
deleted every row/column and did a "Clear All" on the entire thing and
it is still 1.7 MB. There are no hidden or very hidden sheets.

Has anyone ever encountered this? Exporting out the text and starting
over really isn't an option, so I hope someone can help me.

Thanks.


--
octobert
------------------------------------------------------------------------
octobert's Profile: http://www.excelforum.com/member.php...o&userid=28163
View this thread: http://www.excelforum.com/showthread...hreadid=476874