Excel File Growing Without Explanation

K

Kevin

Greetings! I have an Excel file that contain very little data and some
lightweight VBA code. The file is growing very quickly. Yesterday it was 6MB
and now it's up to 11MB without adding any additional data! What is happening
here? Could the file be corrupt? I'm not getting any errors, but VBA seems to
be ignoring my breakpoints when stepping through code.

Your ideas would be appreciated!
 
A

Arvi Laanemets

Hi

Is the file shared ?
What happens when you save the file with another name (Save As dialog from
Excel) ?


Arvi Laanemets
 
K

Kevin

No, the file is not shared.

I tried saving it under a different file name, but the file name remained
the same. I also tried saving it as Excel 97/2000 & 5.0/95 but it increase to
21MB!
 
D

Dave Peterson

saving as that combo type (xl97/xl95) will double the size of the workbook
file--it's essentially two copies of the same workbook.

Maybe you have extended the used range (but that sounds like a pretty big leap
in size).

Debra Dalgleish has some pretty pictures describing how to fix this:
http://www.contextures.com/xlfaqMac.html#NoMacros
 
G

Gord Dibben

Kevin

On a worksheet where do you get to when you hit CRTL + END?

Excel has a nasty habit of not clearing the real used range on sheets when
something has been deleted/cleared.

Lots of your empty cells could be assumed as "used" by Excel.

Your lightweight VBA code could be doing you in.

For fixes see Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP
 
Top