ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   why the size of xls file with empty worksheet could be 3MB? (https://www.excelbanter.com/new-users-excel/121921-why-size-xls-file-empty-worksheet-could-3mb.html)

Denis

why the size of xls file with empty worksheet could be 3MB?
 
Folks, pls. help to find the reason of subject question. really i can't
understand where to dig.

Nick Hodge

why the size of xls file with empty worksheet could be 3MB?
 
Denis

Has it had data in the past? Excel has a real problem clearing it's used
range. If it used to have data it will think it still has unless you
explicitly delete the *entire* rows and columns that contained it and save
the file (Close an re-open XL in versions <2000)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Denis" wrote in message
...
Folks, pls. help to find the reason of subject question. really i can't
understand where to dig.




All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com