Excel file size too large

Thanks, Rob,

 On the empty tab, I tried "Ctrl + End" and "End then Home". The cursor went to A1.

Thanks Seth,

I tried and copied it to a new excel and I got the same issue.

Thanks, Phillip,

I tried to save it as xlsb file, the size is now 55MB, 11Mb less than as .xlsm.

I also tried press Alt + F11 to show the Visual Basic Editor. In the left hand pane there is only one workbook and sheet1.

What about hidden tabs?

Can you go to VBA (press Ctrl+F11) and the immediate windows (Ctrl+G), and enter

for each sht in sheets():debug.print sht.name:next

Afteralt+F11 and Ctrl+G, I went to immediate and got this:

for each sht in sheets():debug.Print sht.name:next
Macro1
Sheet1

So, no excess firmatting and hidden or very hidden sheets.

Are all rows and columns visible?

To check, click the margin cell above the row numbers and left of column headers. Then use the Format button to ensure everything is visible.

Then on  that sheet press F5 and click the Special... Button at the bottom. Select Objects and click OK. If there are no objects, error message will come up saying so. If there are objects they will be selected and can be deleted.

I did the F5 and Select Objects and click OK. There are no objects. It is so puzzling and frustrating.... Hmmm....

I added a new tab and deleted the old sheet1. Then saved it (so slow in saving). It is still 61.6MB as before.
What can it be?! I am pulling my hairs.

I just created an Excel and it is only 25KB. Wonder what is going on with that huge file.

Can you check to see if there are a bunch of formuals and/or rules?

No. I deleted all the tabs but the newest one which has no data.

I just found the original version of the file and its size is only 40KB with exactly
the same infomation.

But how strange that its size is now 61MB after I put it on a shared network drive over a month ago, it becomes so huge!

That last comment has lit a light, possibly!

As well as being on s Shared network drive, does the file have the Shared Workbook feature enabled?

Shared workbooks are notoriously unreliable and can become corrupted, one symptom of which can be file size bloat.

I agree that a shared file might be an issue, but in the "Request for Attention" post (which really shouldn't have been made), the author states that the file is not in shared.  This is all different than being on a shared, network drive.  That should have no effect on the file size.

So, which is it?

Before Jan 20th, it was on C:\ drive; then I made a copy of it and moved it on shared drive with a new name; yesterday I copied it on C:\ drive. I am sorry it is going back and forth.

The original copy was only 37KB. But I discovered that the one on shared drive and copied back is 66MB. They have the same contents.

But I check the new one and found that the shared workbook feature is not turned on.

Have you tried this add-in that performs intelligent reduction (not compression) of Office files?

http://www.neuxpower.com/

I will try it. Thank you!

Before you purchase a third-party application (which appears to focus more on image/pdf file optimization), have you noticed a similar effect with any other Excel files saved on the shared drive?  For example, take a copy of any other Excel file you have, note its size, and save that copy on the shared drive.  Then, copy it back to your computer (C:) and note the size.

If the new file doesn't change sizes, then there is an issue with the first file only.  If the new file does change sizes, I'd recommend that a virus scan be run on on the file server.

-Glenn

Thanks a lot, Glenn.

At this stage, since I have the original Excel file in small size (40KB). I am writing VBA code based on it. I still don't know why the one that went through the network is 61MB and it puzzles me deeply. I tried everything described above to no avail.

I will still poke at it everyday whenever I can get a moment at it, just to satisfy my curiosity.

Thank you to everyone who helped!

Jennifer

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.