• I have a user who has a file of about 8MB with 48,000 lines in it
• When User selects few rows to delete, excel goes into spinning & not ending mode and finally crashes not even from excel but knocks the user out of the system, leaving no choice for him to log in again.
• There are no formulas and calculation is also set to Manual.

Any idea, help or clue to fix this issue

It could be that your file is corrupt, but see what happens if you use a macro:

Sub DelRows()
    Dim xlCalc As XlCalculation
    
    With Application
        .ScreenUpdating = False
        xlCalc = .Calculation
        .Calculation = xlCalculationManual
        .EnableEvents = False
        .DisplayAlerts = False
        
        Selection.EntireRow.Delete
        
        .ScreenUpdating = True
        .EnableEvents = True
        .DisplayAlerts = True
        .Calculation = xlCalc
    End With

End Sub

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 45 minutes ago

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, March 06, 2015 2:35 AM

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, March 06, 2015 2:35 AM

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, March 06, 2015 2:35 AM

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, March 06, 2015 2:35 AM

Hi,

Did this issue only occur with the special file? If yes, I agree with Bernie, please try his suggestion first. And we also can copy/paste all the content of file to a new Excel file to test.

If this issue still exists, please open Event Viewer to check whether there's any error about the Excel crash issue.

Press Win + R, type "eventvwr" in the blank box, press Enter. In the Event Viewer, browse to Windows Logs -> Application, there may be some errors after the crash.

To protect your privacy, you may send the error logs to ibsofc@microsoft.com, we will try to find the cause.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, March 06, 2015 2:35 AM

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Thank you all

I am going to test it today sometime and will post the feedback soon after that

The other isssue is, possibly, with the 'few rows'  Once thing that Excel does poorly at is deleting rows, if the rows are separated from each other. Excel rebuilds the calc-tree after each row deletion, so it is almost always better to sort the rows to be deleted together into a single block prior to the deletion.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor 13 hours 58 minutes ago

The other isssue is, possibly, with the 'few rows'  Once thing that Excel does poorly at is deleting rows, if the rows are separated from each other. Excel rebuilds the calc-tree after each row deletion, so it is almost always better to sort the rows to be deleted together into a single block prior to the deletion.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor Monday, March 09, 2015 5:41 PM

The other isssue is, possibly, with the 'few rows'  Once thing that Excel does poorly at is deleting rows, if the rows are separated from each other. Excel rebuilds the calc-tree after each row deletion, so it is almost always better to sort the rows to be deleted together into a single block prior to the deletion.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor Monday, March 09, 2015 5:41 PM

The other isssue is, possibly, with the 'few rows'  Once thing that Excel does poorly at is deleting rows, if the rows are separated from each other. Excel rebuilds the calc-tree after each row deletion, so it is almost always better to sort the rows to be deleted together into a single block prior to the deletion.

• Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor Monday, March 09, 2015 5:41 PM

Hello,

Do you have any update on this thread?

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

No I have tried to follow the tips provide here but it did not work and so far no fix

Hi,

Have you checked the event log? Was there any error message?

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi Zack,

Is there any update on this thread?

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"