macros and file size
 

Hi. I have an excel file to which I have added several macros. It seems
like this has increased the file size pretty significantly. (~7 MB.....it was
around 1.5 MB). I have since deleted the macros but the file size hasn't
dropped back down. I'm a little stuck here. Any thoughts/suggestions?
Thanks in advance.

Chris

macros and file size
 

Probably not the macros themselves, but the action they took.

Sounds like your worksheets' used range is larger than what you think it is.

See Debra's site for re-setting the used range of a sheet or sheets.

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


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 16:34:00 -0800, CMD wrote:

Hi. I have an excel file to which I have added several macros. It seems
like this has increased the file size pretty significantly. (~7 MB.....it was
around 1.5 MB). I have since deleted the macros but the file size hasn't
dropped back down. I'm a little stuck here. Any thoughts/suggestions?
Thanks in advance.

Chris

macros and file size
 

Worked perfectly!!! Thanks so much!!

Chris

"Gord Dibben" wrote:

Probably not the macros themselves, but the action they took.

Sounds like your worksheets' used range is larger than what you think it is.

See Debra's site for re-setting the used range of a sheet or sheets.

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


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 16:34:00 -0800, CMD wrote:

Hi. I have an excel file to which I have added several macros. It seems
like this has increased the file size pretty significantly. (~7 MB.....it was
around 1.5 MB). I have since deleted the macros but the file size hasn't
dropped back down. I'm a little stuck here. Any thoughts/suggestions?
Thanks in advance.

Chris

macros and file size
 

Good to hear.

Gord

On Tue, 12 Feb 2008 17:03:00 -0800, CMD wrote:

Worked perfectly!!! Thanks so much!!

Chris

"Gord Dibben" wrote:

Probably not the macros themselves, but the action they took.

Sounds like your worksheets' used range is larger than what you think it is.

See Debra's site for re-setting the used range of a sheet or sheets.

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


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 16:34:00 -0800, CMD wrote:

Hi. I have an excel file to which I have added several macros. It seems
like this has increased the file size pretty significantly. (~7 MB.....it was
around 1.5 MB). I have since deleted the macros but the file size hasn't
dropped back down. I'm a little stuck here. Any thoughts/suggestions?
Thanks in advance.

Chris