ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I deleted 99% of data from excel file. Folder Size remains unchang (https://www.excelbanter.com/excel-discussion-misc-queries/46360-i-deleted-99%25-data-excel-file-folder-size-remains-unchang.html)

msnut

I deleted 99% of data from excel file. Folder Size remains unchang
 
I created another test folder and as I deleted data from it I noticed the
size of the file would change too. I compressed the pics in the file in
question and I noticed the size changed but deleting pics, pages, data. Size
remains unchanged. Me very confused!!! Any help please!

Anne Troy

Are you completely deleting the rows/columns? or are you hitting
Edit--Clear--All, then saving?
If not, perhaps your cells are still holding "dirtiness". :) Sometimes, you
just need to copy all the worksheets to a new workbook to get rid of
bloating.
************
Anne Troy
www.OfficeArticles.com

"msnut" wrote in message
...
I created another test folder and as I deleted data from it I noticed the
size of the file would change too. I compressed the pics in the file in
question and I noticed the size changed but deleting pics, pages, data.
Size
remains unchanged. Me very confused!!! Any help please!




msnut

Thanks for your help. I am deleting rows, columns, pics. The folder size
remains at 25.1 M. I have about half a page of numbers nothing else. I also
copied this worksheet to my test folder and the folder size went up 25+ Meg.
I tried compressing the folder on disk size went down about 1/2 meg. Any
suggestions?

"Anne Troy" wrote:

Are you completely deleting the rows/columns? or are you hitting
Edit--Clear--All, then saving?
If not, perhaps your cells are still holding "dirtiness". :) Sometimes, you
just need to copy all the worksheets to a new workbook to get rid of
bloating.
************
Anne Troy
www.OfficeArticles.com

"msnut" wrote in message
...
I created another test folder and as I deleted data from it I noticed the
size of the file would change too. I compressed the pics in the file in
question and I noticed the size changed but deleting pics, pages, data.
Size
remains unchanged. Me very confused!!! Any help please!






All times are GMT +1. The time now is 03:10 AM.

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