Spreadsheet With No Data Is Too Big

Re: One Spreadsheet No Data 8.7mb???

have you checked to see if the book has code in the editor?

Re: One Spreadsheet No Data 8.7mb???

Do you have any formatting in the workbook that extends to the last row?

This may be a potential cause

Re: Spreadsheet With No Data Is Too Big

right click on a sheet tab and select view code

Re: Spreadsheet With No Data Is Too Big

Check this out.

Re: Spreadsheet With No Data Is Too Big

Are you viewing all the worksheets? Could some be Very Hidden (which wouldn't otherwise show under the Format menu)? Try this to check for Very Hidden worksheets:

Sub AllSheetsVisible()
Dim sht As Worksheet
For Each sht In Worksheets
    sht.Visible = True
Next sht
End Sub

Do you use your workbook to query a database? Often, data related to the query will be retained, depending on how you set up code for your query (and particularly so if there is no code for the query), and remain hidden somewhere in Excel-land. Sometimes, data can also be shifted-over from queries. You'd then need to select the areas encompassed by the queries and delete it with code. Selecting the delete key doesn't always delete the data, and might only "clear" the contents (though the actual data could be retained in the background). I had a similar problem with a workbook, which continued to magically grow but had no more data; and this resolved the problem for me. I forget exactly how I set it up offhand, but see if something like this doesn't work on a back-up copy:

Sub DeleteData()
    Range("A1").Select
    Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
    Selection.Delete
Thisworkbook.save
End Sub

Then, check the file-size.

Quote from wisesap

Then I deleted all columns and rows, cleared all columns and rows in the remaining tab. Now I have one blank spreadsheet in a workbook; no hidden columns, no hidden rows, no hidden sheets. The file is now 8.77mb. How can that be?????