Excel sheet not responding

[uswyne]

Hi,
I have excel workbook containing 8 sheets, every sheet working fine except 1 sheet , when I enter any data on that sheet its not respond for while and than its ok. its make my work slow. I check every possibilities even I remove every formula and link also I make a new copy of that sheet but the problem is still remain.

Any idea what should I do?

 

[Z51]

Is there any code attached to that sheet, perhaps triggering a Worksheet_Change event that is stalling or running slowly? Could also look in the Workbook module for SheetChange events there, but not as likely.

In the past I've seen where copying all of the worksheets to a new workbook (one-by-one) will sometimes fix an issue with a sheet - possible corruption that (hopefully) doesn't carry across to the new workbook.

 

[uswyne]

Is there any code attached to that sheet, perhaps triggering a Worksheet_Change event that is stalling or running slowly? Could also look in the Workbook module for SheetChange events there, but not as likely.

In the past I've seen where copying all of the worksheets to a new workbook (one-by-one) will sometimes fix an issue with a sheet - possible corruption that (hopefully) doesn't carry across to the new workbook.

There is no code attached, I copies single entries in new workbook, after 800 entries sheet will hang for a while.