Workbook Size Mystery

[MikeG]

I have been working on a large, 15 meg, workbook.

I added a new worksheet, and the workbook size increased to 18 meg.

I was very suprised, since what I added did not seem that large.

So I copied the worksheet in question to a new workbook and saved it. As expected, the size was 3 megs.

I then systematically started deleting rows and columns and then saving to check the size each time.

I found that I eventually got down to only three cells with content and the model was still about 2.5 megs. I then deleted one of these and the model shrank to a mere 30k.

The cell in question was just a simple formula.

Throughout my experiment, I made sure each time that I checked to see where the end of the sheet was (using Ctrl End) and that was no issue. There were no macros, shapes, or images (as far as I know.)

Has anyone else experienced this type of thing? Does anyone have any ideas what might be going on?

Thanks,

MikeG

 

[ZVI]

Even if shapes are invisible press F5 – Special – Objects – Ok
If "No object found" message is not appeared then press Delete and save workbook.
Please try it with copy of worksheet.

 

[MikeG]

Thanks ZVI - I'll give it a go.

MikeG