Can't delete rows

After deleting unused rows and columns and saving, closing and reopening
your file size is still very large?

What is current file size under File>Properties>General?

You will always have 256 columns and 65536 rows so don't think that deleting
will remove those cells.


Gord

On Wed, 9 Sep 2009 08:28:05 -0700, jabe813
<jabe813 RemoveThis @discussions.microsoft.com> wrote:

>I have tried everything to delete these rows in order to reduce the file size.
>
>Tried a variation of similar direction:
>http://www.contextures.com/xlfaqApp.html#Unused
>
>Any suggestions?? Anyone?
>
>"Gord Dibben" wrote:
>
>> I never mentioned a right-click and delete row but first you may have to
>> turn off automatic calculation.
>>
>> Then follow Shift + End + Downarrow and Edit>Delete>Entire Row.
>>
>>
>> Gord
>>
>> On Fri, 4 Sep 2009 11:14:01 -0700, jabe813
>> <jabe813 RemoveThis @discussions.microsoft.com> wrote:
>>
>> >Do you happen to know what to do if the below does not work?
>> >
>> >I am using Excel 2003. The file is 7MB and needs to be smaller.
>> >
>> >I followed your directions below.
>> >
>> >When I right click the short cut menu options is "Delete Row"
>> >
>> >When I do that it does not ask to 'delete entire row'.
>> >I get an hour glass and in the bottom left corner I get "Calculating Cells:
>> >X%"
>> >When it reaches 100% I still have 65536 rows and then columns that go to IV
>> >
>> >Please help
>> >
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Apologies for the lack of direction about re-setting the used range on a sheet.
>> >>
>> >> The reason you have such a large used range is the copying of formulas down and
>> >> across far more rows and columns than you may reasonably need.
>> >>
>> >> To reset the used range, go to the bottom of your actual data.
>> >>
>> >> Select the row below and SHIFT + End + DownArrow
>> >>
>> >> Edit>Delete>Entire Row.
>> >>
>> >> Do same for all columns to the right of your data.
>> >>
>> >> Do this on all sheets.
>> >>
>> >> Now......important part.........Save/Close and reopen.
>> >>
>> >> What is size of workbook now?
>> >>
>> >> To address the original problem, which is having formulas :just in case" you may
>> >> want to read up on "Dynamic Ranges" at Debra Dalgleish's site.
>> >>
>> >> http://www.contextures.on.ca/xlNames01.html#Dynamic
>> >>
>> >> Formulas can be entered that will look at only the used range.
>> >>
>> >>
>> >> Gord
>> >>
>> >> On Wed, 27 Feb 2008 11:23:03 -0800, JoAnn <JoAnn RemoveThis @discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >The file size is 20,073KB.
>> >> >
>> >> >What do you mean by "reset the used range on all sheets"? I haven't done
>> >> >that since I didn't know I had to and don't know how to do it. I couldn't
>> >> >find anything in Help on it. Please explain what I have to do.
>> >> >
>> >> >The only ranges I have set are the sections I'm using for calculations. But
>> >> >when I format or add a formula to a cell/column/row, I generally copy it down
>> >> >so it exists in all worksheet rows/columns (I use the keyboard sequence
>> >> >Ctrl-Shift-DownArrow to select them then paste my formula or formatting
>> >> >change). That's when I noticed that I had a lot of rows. Could that be
>> >> >causing a problem?
>> >> >
>> >> >Thanks for all your help with this!
>> >> >JoAnn
>> >>
>> >>
>>
>>

I repeat my offer

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1.DeleteThis@austin.rr.com
"jabe813" <jabe813.DeleteThis@discussions.microsoft.com> wrote in message
news:307F37C1-A91F-4194-95ED-EEE079F7D3BD@microsoft.com...
>I have tried everything to delete these rows in order to reduce the file
>size.
>
> Tried a variation of similar direction:
> http://www.contextures.com/xlfaqApp.html#Unused
>
> Any suggestions?? Anyone?
>
> "Gord Dibben" wrote:
>
>> I never mentioned a right-click and delete row but first you may have to
>> turn off automatic calculation.
>>
>> Then follow Shift + End + Downarrow and Edit>Delete>Entire Row.
>>
>>
>> Gord
>>
>> On Fri, 4 Sep 2009 11:14:01 -0700, jabe813
>> <jabe813.DeleteThis@discussions.microsoft.com> wrote:
>>
>> >Do you happen to know what to do if the below does not work?
>> >
>> >I am using Excel 2003. The file is 7MB and needs to be smaller.
>> >
>> >I followed your directions below.
>> >
>> >When I right click the short cut menu options is "Delete Row"
>> >
>> >When I do that it does not ask to 'delete entire row'.
>> >I get an hour glass and in the bottom left corner I get "Calculating
>> >Cells:
>> >X%"
>> >When it reaches 100% I still have 65536 rows and then columns that go to
>> >IV
>> >
>> >Please help
>> >
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Apologies for the lack of direction about re-setting the used range on
>> >> a sheet.
>> >>
>> >> The reason you have such a large used range is the copying of formulas
>> >> down and
>> >> across far more rows and columns than you may reasonably need.
>> >>
>> >> To reset the used range, go to the bottom of your actual data.
>> >>
>> >> Select the row below and SHIFT + End + DownArrow
>> >>
>> >> Edit>Delete>Entire Row.
>> >>
>> >> Do same for all columns to the right of your data.
>> >>
>> >> Do this on all sheets.
>> >>
>> >> Now......important part.........Save/Close and reopen.
>> >>
>> >> What is size of workbook now?
>> >>
>> >> To address the original problem, which is having formulas :just in
>> >> case" you may
>> >> want to read up on "Dynamic Ranges" at Debra Dalgleish's site.
>> >>
>> >> http://www.contextures.on.ca/xlNames01.html#Dynamic
>> >>
>> >> Formulas can be entered that will look at only the used range.
>> >>
>> >>
>> >> Gord
>> >>
>> >> On Wed, 27 Feb 2008 11:23:03 -0800, JoAnn
>> >> <JoAnn.DeleteThis@discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >The file size is 20,073KB.
>> >> >
>> >> >What do you mean by "reset the used range on all sheets"? I haven't
>> >> >done
>> >> >that since I didn't know I had to and don't know how to do it. I
>> >> >couldn't
>> >> >find anything in Help on it. Please explain what I have to do.
>> >> >
>> >> >The only ranges I have set are the sections I'm using for
>> >> >calculations. But
>> >> >when I format or add a formula to a cell/column/row, I generally copy
>> >> >it down
>> >> >so it exists in all worksheet rows/columns (I use the keyboard
>> >> >sequence
>> >> >Ctrl-Shift-DownArrow to select them then paste my formula or
>> >> >formatting
>> >> >change). That's when I noticed that I had a lot of rows. Could that
>> >> >be
>> >> >causing a problem?
>> >> >
>> >> >Thanks for all your help with this!
>> >> >JoAnn
>> >>
>> >>
>>
>>