Share via

Insert row in Excel not working

Anonymous
2024-06-12T18:55:06+00:00

I copy a row in Excel and try to insert it above the copied row.
Excel hangs and does not complete the operation.
I also try hitting F9 and Shift-F9 and nothing happens.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2024-06-20T18:10:41+00:00

    New version comes.

    Release notes for Current Channel releases - Office release notes | Microsoft Learn

    Excel

    • This fix rectifies a problem in Excel where inserting or deleting cells might occasionally fail, leading to formulas recalculating inaccurately.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-06-14T06:25:13+00:00

    As workaround, you may try setting calculation option to manual when you insert rows.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-06-13T00:16:50+00:00

    This is bug on current Excel version. You may try rollbacking office update

    ODT tool

    How to revert to an earlier version of Office - Microsoft Support

    Or CMD

    1. Start an Office application (such as Excel), and then select File > Account. select Update Options > Disable Updates.
    2. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator
    3. Copy/paste these two commands one at a time and press enter

    cd %programfiles%\Common Files\Microsoft Shared\ClickToRun

    officec2rclient.exe /update user updatetoversion=16.0.17531.20152

    Was this answer helpful?

    0 comments No comments