Excel 2007 pressing enter lag

[teatimecrumpet]

Hi,

Not sure what is going on but when I enter dat into one cell (as little as 3 characters) and press the enter button excel will take a long time to move onto the next cell. In the bottom right app border it will show a calculating progress percentage and tell me how many processors are being used.

But if I just input data and select another cell with the mouse cursor it is fine.

Any reason for the calculation lag?

Note: I was playing around with some "application.cutcopymode = false" earlier have since just made a simple macro to set that to true...don't think this would be a problem woudl it?

Thanks,

 

[teatimecrumpet]

Don't know exacly why this would do this.

But was looking at the code I was playing with and I had set screen updating to false twice one after the other. Have since deleted the second instance and reran the code. And all is well now.

No idea why that would be the case.

(by the way the code was looping through a folder of files and running code)

 

[teatimecrumpet]

Scratch That.

It is now working slowly again.

It seems to be happening after I filter out a sheet and then copying the filtered list to a new workbook.


The rows of data are only 943 and there are only 26 columns. No formulas.

 

[RoryA]

Selecting another cell with the mouse will often interrupt the calculation process - it will then resume again once the application has been idle for a little while.. It sounds as though you have a lot of recalculation going on in the workbook.

 

[teatimecrumpet]

Don't know why I would though. Since there are no formulas in two open workbooks that I'm trying to use.

Is there a cache I need to clear or something?

 

[RoryA]

If it's calculating there must be some formulas somewhere in an open workbook.
What does your code do, and how is it triggered?

 

[teatimecrumpet]

Sorry rorya. There was a hidden worksheet updating.

thanks for the followups...is there a way to delete whole threads when I look like a jerk?

 

[RoryA]

No, but don't worry - we've all been there. And hopefully, someone else will benefit in future.