none
Office/Excel 365 1808 - in a workbook with several thousands of rows - deleting filtered rows by ex. color takes very long time, freezes Excel. RRS feed

  • Question

  • In Office/Excel 365 1808 ProPlus 64-bit- in a workbook with several thousands of rows - deleting filtered rows by ex. color takes very long time, freezes Excel.

    Office 365 is patched with latest monthly cumulative update.

    Deleting of filtered rows, several thousand rows, freezes Excel and takes very long time to delete (compared with O2031 32-bit and O365 1803 64-bit).

    Office 2013 32-bit and Office/Excel 365 1803 64-bit does not have this problem. 

    Can be easily replicated.

    Has anyone experienced it, are there any workarounds or updates from Microsoft?

    Wednesday, April 17, 2019 2:40 PM

All replies

  • Hi,

    Where did you get the Excel workbook? Did the issue occur in a single Excel workbook or all Excel workbooks? 

    Do you mean that you have tested the problem in Office 2013 32-bit and Office/Excel 365 1803 64-bit? It is the same Excel workbook which you test in the Office 2013 32-bit and Office/Excel 365 1803 64-bit?

    What’s the computer’s operating system which have installed Office 2013 32-bit and Office/Excel 365 1803 64-bit? And what’s your computer’s operating system which have installed Office/Excel 365 1808 ProPlus 64-bit?

    And maybe you can try the following steps:

    1. Running excel in safe mode (Press Win + R, type “excel /safe”, press Enter.) and check the result.
    2. If the issue still persists, try to repair office 365.

    Any update, feel free to post back.

    Regards,

    Bella Wu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, April 18, 2019 10:21 AM
    Moderator
  • Hi,

    How is everything going on with this issue?

    Please remember to mark the replies as answers if they helped. And if you need further assistance on this, please feel free to post back.

    Regards,

    Bella Wu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, April 22, 2019 2:23 AM
    Moderator
  • The workbook is created with Excel 365 ProPlus x64 1808 Semi Annual Channel. Office is up to date, monthly updates are always applied, Windows is up to date.

    Workbook has around 14000 rows, some of them have color, ex. Orange. 

    Filtering by row color done.

    Then select all filtered rows and try to delete. It takes a very-very long time. Can be replicated only in O365 1808. It cannot be replicated on O365 1803 or Office 2013. 

    I do not have workaround for this other than copy data in O2013 and delete and copy them back. But this is not a solution.

    Tuesday, April 30, 2019 9:10 PM
  • Hi,

    Do you mind sending the workbook to us for testing?

    You can send the Excel workbook to the GBSD TN Office Information Collection: ibsofc@microsoft.com. Please involve the thread URL in the email message for easy follow-up.

    Please remember to remove all your personal information like email address or company information before posting.

    Regards,

    Bella Wu


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Friday, May 3, 2019 2:11 AM
    Moderator
  • Thanks, we have a ticket opened with Microsoft on this. It seems they agreed on the issue and are working. Will share if I have any more updates.

    Tuesday, May 28, 2019 4:18 PM