Cannot reduce size of file although deleted whole data from all sheets

My security software has blocked your site....

Take a look here. This is th emost usual cause:

https://www.techrepublic.com/blog/mi...orkbook-bloat/

Hi caabdul

I could download it, but Glenn's pointer to the usual cause isn't the culprit in this case - although, all too often, it is. I have tried deleting all the columns, and all the rows, but the last cell keeps on defaulting to A1048576, and this is what's causing the huge file size.

You could delete this tab, and that would fix it, bringing the workbook size to 42kb, but I admit to being a little mystified at the underlying cause.

As an aside, I suggest you delete this file from files.fm - it appears to have some personal data left over which hasn't been deleted.

HTH

DominicB

I havent read Glen's link.

Create a new file and copy each page from the old file to the new file.
Save the new file.

See if that's any better, sometimes it works.

Originally Posted by Special-K

Create a new file and copy each page from the old file to the new file.

I also tried this - it didn't work.
I also tried the old chestnut of saving to .html, and then converting back to an Excel file. No joy there …

DominicB