Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lunker55
 
Posts: n/a
Default Blank file is 316k. Why

I have been having a problem opening a file, so I deleted all data, named
ranges, Macros, etc,
and the file size is still 316k. Should it not be more than about 14k?
Any idea why???

Joe


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

How many worksheets are in your workbook?

Any pictures? Any objects at all?

For each worksheet, if you hit ctrl-end, do you end up in A1?

Debra Dalgleish has some techniques to reset that last used cell:
http://www.contextures.com/xlfaqApp.html#Unused

lunker55 wrote:

I have been having a problem opening a file, so I deleted all data, named
ranges, Macros, etc,
and the file size is still 316k. Should it not be more than about 14k?
Any idea why???

Joe


--

Dave Peterson
Reply
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
existing excel file when clicked opens blank excel document snows_24 Excel Discussion (Misc queries) 1 May 21st 05 07:15 PM
Excel file opens with a blank screen Meagan Excel Discussion (Misc queries) 1 April 18th 05 05:37 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM
Excel File Appears Blank Tony C. Excel Discussion (Misc queries) 2 December 7th 04 12:59 AM


All times are GMT +1. The time now is 05:04 AM.

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

About Us

"It's about Microsoft Excel"