When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson

i have a similar problem

when removing a large picture form the spreadsheet the filesize stays big,
2MB rather than 15K

I have copied over the rows (1-8) that were not part of the image object
(kind of hard to find whre the object lives) into a new worksheet in the same
file, but the size stays the same.

ONly when creating new spreadsheet and then copying and pasting the 8 rows
into there and then saving this new file results in a file of 15K size.

Any idea how to release memory from a large image object that has been
deleted, but its memory is still lingering in a library of some sort witiin
that xls?

thx
Arjen
"Dave Peterson" wrote:

Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson

Are you sure you got all the shapes?

Maybe you have a few (or one giant) shape that's not visible. A little macro
may help find those shapes.

Option Explicit
Sub testme()
Dim myShape As Shape
For Each myShape In ActiveSheet.Shapes
myShape.Visible = True
Next myShape
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Arjen wrote:

i have a similar problem

when removing a large picture form the spreadsheet the filesize stays big,
2MB rather than 15K

I have copied over the rows (1-8) that were not part of the image object
(kind of hard to find whre the object lives) into a new worksheet in the same
file, but the size stays the same.

ONly when creating new spreadsheet and then copying and pasting the 8 rows
into there and then saving this new file results in a file of 15K size.

Any idea how to release memory from a large image object that has been
deleted, but its memory is still lingering in a library of some sort witiin
that xls?

thx
Arjen
"Dave Peterson" wrote:

Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson


--

Dave Peterson

example at http://www.solvesmart.com/xls/

THANKS for the quick reply
I created a button, assigned the macro, and ran it. Nothing showed up. I
also went to EDIT - GOTO SPECIAL and selected OBJECTS, also nothing.

I ahve in the meanwhile inserted a new worksheet SHEET1, and deleted the
oringial sheet all together. the good thing should be, there is no old sheet,
the bad thing might be that i have distroyed the only link to the lingereing
memory

Perhaps then only via VB i can delete it, by releasing all memory of all
objects, if i knew where it was hiding

I have about 100 files that all have a large image that i will have to
remove, and i also have to reduce the filesizes from 2 MB to 15 or so K for
each.

I have posted the test spreadsheet on http://www.solvesmart.com/xls/
as TEST01.xls

Let me know if there is still hope, also considering that hte other 99 files
actually have the picture object still visibily sitting there, and i wil
lhave to find a method to delete those. This testing file is just showing the
after math of deleting the object from the first file

THanks

"Dave Peterson" wrote:

Are you sure you got all the shapes?

Maybe you have a few (or one giant) shape that's not visible. A little macro
may help find those shapes.

Option Explicit
Sub testme()
Dim myShape As Shape
For Each myShape In ActiveSheet.Shapes
myShape.Visible = True
Next myShape
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Arjen wrote:

i have a similar problem

when removing a large picture form the spreadsheet the filesize stays big,
2MB rather than 15K

I have copied over the rows (1-8) that were not part of the image object
(kind of hard to find whre the object lives) into a new worksheet in the same
file, but the size stays the same.

ONly when creating new spreadsheet and then copying and pasting the 8 rows
into there and then saving this new file results in a file of 15K size.

Any idea how to release memory from a large image object that has been
deleted, but its memory is still lingering in a library of some sort witiin
that xls?

thx
Arjen
"Dave Peterson" wrote:

Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson


--

Dave Peterson

I don't open files.

Maybe you have a used range that's way off from what you think it should be.

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

Arjen wrote:

example at http://www.solvesmart.com/xls/

THANKS for the quick reply
I created a button, assigned the macro, and ran it. Nothing showed up. I
also went to EDIT - GOTO SPECIAL and selected OBJECTS, also nothing.

I ahve in the meanwhile inserted a new worksheet SHEET1, and deleted the
oringial sheet all together. the good thing should be, there is no old sheet,
the bad thing might be that i have distroyed the only link to the lingereing
memory

Perhaps then only via VB i can delete it, by releasing all memory of all
objects, if i knew where it was hiding

I have about 100 files that all have a large image that i will have to
remove, and i also have to reduce the filesizes from 2 MB to 15 or so K for
each.

I have posted the test spreadsheet on http://www.solvesmart.com/xls/
as TEST01.xls

Let me know if there is still hope, also considering that hte other 99 files
actually have the picture object still visibily sitting there, and i wil
lhave to find a method to delete those. This testing file is just showing the
after math of deleting the object from the first file

THanks

"Dave Peterson" wrote:

Are you sure you got all the shapes?

Maybe you have a few (or one giant) shape that's not visible. A little macro
may help find those shapes.

Option Explicit
Sub testme()
Dim myShape As Shape
For Each myShape In ActiveSheet.Shapes
myShape.Visible = True
Next myShape
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Arjen wrote:

i have a similar problem

when removing a large picture form the spreadsheet the filesize stays big,
2MB rather than 15K

I have copied over the rows (1-8) that were not part of the image object
(kind of hard to find whre the object lives) into a new worksheet in the same
file, but the size stays the same.

ONly when creating new spreadsheet and then copying and pasting the 8 rows
into there and then saving this new file results in a file of 15K size.

Any idea how to release memory from a large image object that has been
deleted, but its memory is still lingering in a library of some sort witiin
that xls?

thx
Arjen
"Dave Peterson" wrote:

Maybe resetting the last used cell would help:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused



MMcCullough wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Since you have deleted the data already, you should be able to hit save.
This should reduce the sheet to the used cells.

"MMcCullough" wrote:

When I delete information from a large number of cells (or clear contents) on
a worksheet, the amount of memory allocated and the file size of the
application apparently is not re-allocated to reflect that these cells are no
longer being used. How can I "release" the cells whose contents have been
deleted or cleared? Thanks.
--
Mike McCullough