I'm completely baffled.

I hope someone can help.

I created a workbook in which I copy information which is
in a table on a web page and paste this directly into
Excel.

Then I run a macro which reformats this data, and sorts
it a couple of times in different sections.

Two problems have arisen.

First, whenever the data is copied from the Webpage, it
seems to take a very long time before the paste in Excel
finished doing it's thing and allows me to manipulate the
data. This problem has been there from the very
beginning. Always a long delay between doing the "Copy"
of the selected data, and Excel finishing the "Paste"
function.

Next, problem is something that has only come to light
recently. The macros have started running slower and
slower. It has gotten to the point where it now takes
about 15 or 20 minutes to sort about 30 lines of data
(about 30 columns).

I've noted that the Excel file has become humoungous in
size...well over 9 MB, which makes me think that somehow
the file is accumulating a lot of garbage, but I can't
see anything except for the data and formulas which I put
in the cells. I'm very suspicions that the bloated size
has something to do with the problem because at one point
Excel closed and generated a recovered file which
contained most of the formulas except for a pair of user
defined functions, and this only occupied about 150 KB
when it was saved.

Oh, I've tried clearing out all my temp files ...that
doesn't make any difference.

What can I try next?

Jack

Where does CRTL + END take you?

Excel can over-estimate where the "real" used range is. This is the most
common cause of "Bloat".

If CRTL + END takes you far below and to the right of what you know is the
real used range, select all rows below your data and EditDelete.

Do the same for Columns to the right.

Save you workbook and in some versions you will have to Close and re-open to
see the difference.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Wed, 30 Jul 2003 16:17:46 -0700, "jfeka" wrote:

I'm completely baffled.

I hope someone can help.

I created a workbook in which I copy information which is
in a table on a web page and paste this directly into
Excel.

Then I run a macro which reformats this data, and sorts
it a couple of times in different sections.

Two problems have arisen.

First, whenever the data is copied from the Webpage, it
seems to take a very long time before the paste in Excel
finished doing it's thing and allows me to manipulate the
data. This problem has been there from the very
beginning. Always a long delay between doing the "Copy"
of the selected data, and Excel finishing the "Paste"
function.

Next, problem is something that has only come to light
recently. The macros have started running slower and
slower. It has gotten to the point where it now takes
about 15 or 20 minutes to sort about 30 lines of data
(about 30 columns).

I've noted that the Excel file has become humoungous in
size...well over 9 MB, which makes me think that somehow
the file is accumulating a lot of garbage, but I can't
see anything except for the data and formulas which I put
in the cells. I'm very suspicions that the bloated size
has something to do with the problem because at one point
Excel closed and generated a recovered file which
contained most of the formulas except for a pair of user
defined functions, and this only occupied about 150 KB
when it was saved.

Oh, I've tried clearing out all my temp files ...that
doesn't make any difference.

What can I try next?

Jack

Adding to the previus comment if the Workbook is in a ShareMode turnoff
"Keep History" .
"Gord Dibben" wrote in message
...
Where does CRTL + END take you?

Excel can over-estimate where the "real" used range is. This is the most
common cause of "Bloat".

If CRTL + END takes you far below and to the right of what you know is the
real used range, select all rows below your data and EditDelete.

Do the same for Columns to the right.

Save you workbook and in some versions you will have to Close and re-open
to
see the difference.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Wed, 30 Jul 2003 16:17:46 -0700, "jfeka" wrote:

I'm completely baffled.

I hope someone can help.

I created a workbook in which I copy information which is
in a table on a web page and paste this directly into
Excel.

Then I run a macro which reformats this data, and sorts
it a couple of times in different sections.

Two problems have arisen.

First, whenever the data is copied from the Webpage, it
seems to take a very long time before the paste in Excel
finished doing it's thing and allows me to manipulate the
data. This problem has been there from the very
beginning. Always a long delay between doing the "Copy"
of the selected data, and Excel finishing the "Paste"
function.

Next, problem is something that has only come to light
recently. The macros have started running slower and
slower. It has gotten to the point where it now takes
about 15 or 20 minutes to sort about 30 lines of data
(about 30 columns).

I've noted that the Excel file has become humoungous in
size...well over 9 MB, which makes me think that somehow
the file is accumulating a lot of garbage, but I can't
see anything except for the data and formulas which I put
in the cells. I'm very suspicions that the bloated size
has something to do with the problem because at one point
Excel closed and generated a recovered file which
contained most of the formulas except for a pair of user
defined functions, and this only occupied about 150 KB
when it was saved.

Oh, I've tried clearing out all my temp files ...that
doesn't make any difference.

What can I try next?

Jack

Steve, I tried your solution, no luck....still a hugh
file and long delays in just about everything.


Any other ideas?

Jack
-----Original Message-----
Where does CRTL + END take you?

Excel can over-estimate where the "real" used range is.
This is the most
common cause of "Bloat".

If CRTL + END takes you far below and to the right of
what you know is the
real used range, select all rows below your data and
EditDelete.

Do the same for Columns to the right.

Save you workbook and in some versions you will have to
Close and re-open to
see the difference.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Wed, 30 Jul 2003 16:17:46 -0700, "jfeka"
wrote:

I'm completely baffled.

I hope someone can help.

I created a workbook in which I copy information which
is
in a table on a web page and paste this directly into
Excel.

Then I run a macro which reformats this data, and sorts
it a couple of times in different sections.

Two problems have arisen.

First, whenever the data is copied from the Webpage, it
seems to take a very long time before the paste in
Excel
finished doing it's thing and allows me to manipulate
the
data. This problem has been there from the very
beginning. Always a long delay between doing
the "Copy"
of the selected data, and Excel finishing the "Paste"
function.

Next, problem is something that has only come to light
recently. The macros have started running slower and
slower. It has gotten to the point where it now takes
about 15 or 20 minutes to sort about 30 lines of data
(about 30 columns).

I've noted that the Excel file has become humoungous in
size...well over 9 MB, which makes me think that
somehow
the file is accumulating a lot of garbage, but I can't
see anything except for the data and formulas which I
put
in the cells. I'm very suspicions that the bloated
size
has something to do with the problem because at one
point
Excel closed and generated a recovered file which
contained most of the formulas except for a pair of
user
defined functions, and this only occupied about 150 KB
when it was saved.

Oh, I've tried clearing out all my temp files ...that
doesn't make any difference.

What can I try next?

Jack

.