LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Anik
 
Posts: n/a
Default Empty Workseek: File still too large (>300k)

Hi,
I have an Excel file of 1 worksheet, containing data in about 20 rows by
20 columns, which is 310 kB ! I noticed copying the range of cells A3:E7
and pasting it doubles the file size, but I cannot find anything wrong in
those cells. I tried the following:
1) If I copy all worksheet and paste it in a new worksheet file, the new
file size is the same, 300kB
2) If I copy and paste all the data column by column, the new file size is
16 kB !
3) If I copy all worksheet and paste values only, the new file size is 14
kB
4) If I delete all the data and the cell formats in the original
worksheet, I still get a large size of 300 kB !
This is weird. I have nothing in the worksheet, no hidden worksheet, and I
really deleted the rows and columns by selecting them and pressing DELETE.
When I press CTRL-END, the cursor stays at cell A1.
I did save the files under different names, I even closed and opened
Excel. I can send you the file if you wish, you'll see it is emply and
still 300kB

Please help me understand what is wrong with my file !

Thanks,
Anik
 
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
Troubel with compression of a very large Excel file Thorsten Pollmeier Excel Discussion (Misc queries) 3 January 15th 08 01:15 PM
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
My excel file is too large (5 mb) when it shouldn't be, why? Kenview Excel Discussion (Misc queries) 1 February 26th 05 09:14 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM


All times are GMT +1. The time now is 01:24 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"