Data Entry very slow ... Slow to start WOrksheet_Change
 

I'm working on a workbook where the data entry is VERY SLOW. It didn't used
to be, but today it is.

I've changed calculation to MANUAL and it's no better.

I've set EnableEvents = False and it's faster but still slow. It's just
very slow to allow me to select a cell.

FWIW, the worksheet has some calculations, but does not have a lot of
calculated cells. It's currently filtered and it's taking a long time to
allow me to select a filter.

Has anyone seen this and what do I need to do to fix it.
--
HTH,

Barb Reinhardt

Data Entry very slow ... Slow to start WOrksheet_Change
 

It's taking 3 seconds to do this

Application.ScreenUpdating = True

And 4 seconds to do this

Application.Calculation = XLCalculationAutomatic

What gives?

Thanks,

Barb Reinhardt



"Barb Reinhardt" wrote:

I'm working on a workbook where the data entry is VERY SLOW. It didn't used
to be, but today it is.

I've changed calculation to MANUAL and it's no better.

I've set EnableEvents = False and it's faster but still slow. It's just
very slow to allow me to select a cell.

FWIW, the worksheet has some calculations, but does not have a lot of
calculated cells. It's currently filtered and it's taking a long time to
allow me to select a filter.

Has anyone seen this and what do I need to do to fix it.
--
HTH,

Barb Reinhardt

your question
 

you gave a good description - I can't think of anything else obvious happening in Excel offhand. make sure you have record macros turned off (you may have hit by mistake).

beyond that the first thing I would do is restart your computer to ensure you have enough available free memory and aren't running simple tasks in virtual memory. assuming you've already tried this then memory should not really be a problem. next I would close your file, open a new (blank) workbook and see if you have the same issue.

if it's still occurring, also make sure you don't have a full virus scan, huge print job, or some other resource hog running in the background that would slow you down.



Barb Reinhardt wrote:

Data Entry very slow ... Slow to start WOrksheet_Change
30-Nov-09

I am working on a workbook where the data entry is VERY SLOW. It did not used
to be, but today it is.

I have changed calculation to MANUAL and it is no better.

I have set EnableEvents = False and it is faster but still slow. it is just
very slow to allow me to select a cell.

FWIW, the worksheet has some calculations, but does not have a lot of
calculated cells. it is currently filtered and it is taking a long time to
allow me to select a filter.

Has anyone seen this and what do I need to do to fix it.
--
HTH,

Barb Reinhardt

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
..NET 2.0 Application Restart When it Goes "KABOOM"
http://www.eggheadcafe.com/tutorials...tion-rest.aspx

your question
 

you gave a good description - I can't think of anything else obvious happening in Excel offhand. make sure you have record macros turned off (you may have hit by mistake).

beyond that the first thing I would do is restart your computer to ensure you have enough available free memory and aren't running simple tasks in virtual memory. assuming you've already tried this then memory should not really be a problem. next I would close your file, open a new (blank) workbook and see if you have the same issue.

if it's still occurring, also make sure you don't have a full virus scan, huge print job, or some other resource hog running in the background that would slow you down.



Barb Reinhardt wrote:

Data Entry very slow ... Slow to start WOrksheet_Change
30-Nov-09

I am working on a workbook where the data entry is VERY SLOW. It did not used
to be, but today it is.

I have changed calculation to MANUAL and it is no better.

I have set EnableEvents = False and it is faster but still slow. it is just
very slow to allow me to select a cell.

FWIW, the worksheet has some calculations, but does not have a lot of
calculated cells. it is currently filtered and it is taking a long time to
allow me to select a filter.

Has anyone seen this and what do I need to do to fix it.
--
HTH,

Barb Reinhardt

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BASICS: Forms Authentication in ASP.NET 2.0
http://www.eggheadcafe.com/tutorials...thenticat.aspx

your question
 

you gave a good description - I can't think of anything else obvious happening in Excel offhand. but make sure you have record macros turned off (you may have hit by mistake).

beyond that the first thing I would do is restart your computer to ensure you have enough available free memory and aren't running simple tasks in virtual memory. assuming you've already tried this then memory should not really be a problem. next I would close your file, open a new (blank) workbook and see if you have the same issue.

if it's still occurring, also make sure you don't have a full virus scan, huge print job, or some other resource hog running in the background that would slow you down.



Barb Reinhardt wrote:

Data Entry very slow ... Slow to start WOrksheet_Change
30-Nov-09

I am working on a workbook where the data entry is VERY SLOW. It did not used
to be, but today it is.

I have changed calculation to MANUAL and it is no better.

I have set EnableEvents = False and it is faster but still slow. it is just
very slow to allow me to select a cell.

FWIW, the worksheet has some calculations, but does not have a lot of
calculated cells. it is currently filtered and it is taking a long time to
allow me to select a filter.

Has anyone seen this and what do I need to do to fix it.
--
HTH,

Barb Reinhardt

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET SqlCacheDependency Redux
http://www.eggheadcafe.com/tutorials...dependenc.aspx