| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unusual File Size in Excel file | Excel Discussion (Misc queries) | |||
| how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
| Excel '00, 1st file has macros, how to stop macro in 2nd file? | Excel Discussion (Misc queries) | |||
| Unable to open excel file and when view the file size show as 1 KB | Excel Discussion (Misc queries) | |||
| save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Hybrid Mode
