LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot open excel file, please help!!! sunlite Excel Discussion (Misc queries) 0 September 5th 05 05:29 PM
Unable to create any link/hyperlinks in a particular excel file Nabanita Excel Discussion (Misc queries) 0 June 21st 05 11:52 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 02:19 PM


All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"