Excel File still large after deleting everything

I've been working in an Excel file and my major restriction is size. In my effort to pinpoint whatever increases the size of the file,
I ended up deleting all worksheets, all userforms, all modules & class modules until nothing is left standing. The empty file though
doesn't seem so empty...In my search for a solution, I've stumbled across some VBA codes to -DeleteMissingItems-, to DeleteOldItems,
to delete shapes, objects etc etc. So far, nothing has worked and the file is still 1.2MB large when totally empty.

Does anyone has the knowledge to help getting rid of that useless 1,2MB?

PS. There is a piece of VBA code in the original file that copy-paste ranges to another instance of Excel.
I make a note of this, because I've read something about Excel keeping data relevant to external connections.

Thank you in advance.-

deleting evertthing is not possble at least one sheet must have been left.

try look for objects that are hidden by vba or
recently I was given a file that was supposedly empty but it had 15000 small objects (pictures) with where transparent and no borderline so were not visable
this happens a lot when data is copied from websites trhu copy and paste.

fastest way to find if there are objects is to press F5 > click special button > select objects

.
Two other things to try ...

If you save the workbook as .xlsb (binary) it substantially reduces the size.

Secondly, if you run this macro on the workbook (paste it into a routine module and run), it will check for unseen, residual "data" sitting in cells below the last row/column of what is visible ...
and then it will delete that "data".

Please Login or Register  to view this content.

The other method of performing the same task as the macro is to go sheet by sheet ... find the last row of data / highlight that row and all the rows below it until you reach the bottom of the sheet, then
right click the highlighted region and select DELETE or CLEAR CONTENTS. This method is time consuming and labor intensive.

Special-K -
I've tried that but I came across several reference problems...let alone the fact it's time consuming,
it isn't a permanent solution, since whatever caused that 1.2 MB to appear, will do it again.

Roel Jongman
I've created a new totally empty sheet and deleted everything else.
As far as objects, I've looked for them using the same way you suggested... There are no objects.

Logit
I'm not sure I can save the file as .xlsb (binary) since I'm using Excel 2003 or if such file extension might cause any data loss.
As far as the code to delete everything, i've tried it but it didn't find anything to delete. In Excel 2003 there are no hidden sheets anyway.

Thank you all for the replies, I've been struggling with this project for a few years now but this problem extends beyond my grasp of coding.
Any help is appreciated.

Maybe try zip this file then unzip

Sandy666 , already tried that - No luck either.

if there is no sensitive data, zip it and post here

I'll upload the not so empty file. Hopefully it does not have any hidden sensitive info.

PS. I've tried what Logit suggested and saved the "empty" file as a binary file using Excel 2010.
It did turn the file to 14k as it should of been in the first place but that would likely cause trouble
when I try to revert to Excel 2003.

maybe this one will work for you:

Glenn Kennedy
What version of Excel did you use and what do you mean from cell A10?
...Because when I press ctrl + End in Excel 2003 it takes me to A1.

I should note that the empty file is of no actual use, just a medium to find a way
to get rid of that bloat and then apply it to the Main Excel file.

I've read the instructions very carefully. I've tried it in Excel 2010 and it works just fine.

The problem is that this method -does not work on Excel 2003- and even if it did, it would give me no idea how to
remove bloat from my main file, since I can't follow the same procedure without loss of data.

Is there a way to detect that useless data via VBA and rid of it?

What custom cell styles?!

find, download and install Ex'97
open your file (agree with everything)
save (again agree)

that's all

Thanks for the suggestion xlnitwit, for a moment I thought this would be it...Yet 2003 doesn't like the solution.
I also used the following code to make sure the styles get deleted.

Please Login or Register  to view this content.

I will try and do what you suggested in compatibility mode in Excel 2010, maybe I'm lucky.

Sandy666, I'm sorry I have no idea what this Ex'97 is and any searches I've made returned nothing.

Excel 97 .

Sandy666, I've tried using Excel 97 in the past and unfortunately messes up some of my formulas.

xlnitwit
I've tested it in Excel 2010 and it works exactly as you said. There are 2 extra styles and if deleted the size goes back to normal.
It's very disturbing that in 2003, I can see many more of those styles(>10) and if deleted, there is no change in size at all.

At least the false size is not some secret unreachable data that will magically re-appear(Hopefully), if finally manage to get rid of it.
That's a start, I guess...If anyone can do it in 2003, please share.

Thanks again.