Update & Upgrade Problems

Fix Excel Cannot Insert or Delete Rows in Bloomberg Data Workbooks

Huda Qurayshi Sep 28, 2026 869 views

Question details

Users are unable to insert or delete rows and cells in an Excel workbook connected to live Bloomberg data.

How to Fix Excel Cannot Insert or Delete Rows in Workbooks with Bloomberg Data

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to modify the layout or structure of a workbook by adding or removing rows after a recent software update.
Observed behavior: Excel prevents the insertion or deletion of rows and cells, and formulas may incorrectly recalculate due to an update bug.

Before you start

Before attempting any fixes, save a local copy of your workbook and verify your current Microsoft 365 version by navigating to File > Account in Excel.

Solution 1Recommended

Install the Latest Microsoft 365 Update

Applying the latest Microsoft patch resolves the known bug that causes cell and row manipulation failures.

Microsoft has acknowledged this issue as a bug where inserting or deleting cells occasionally fails and disrupts formula calculations. A fix has been rolled out in the latest Office releases.

Open Excel Account Settings

Launch Microsoft Excel, click on 'File' in the top-left ribbon, and select 'Account' at the bottom of the left-hand navigation pane.

Check for Updates

Under the 'Product Information' section, click the 'Update Options' button and select 'Update Now' from the drop-down menu.

Apply and Restart

Wait for Microsoft 365 to download and install the updates. Once the process is complete, restart Excel and attempt to insert or delete rows in your Bloomberg workbook.

Patch Available: Microsoft successfully patched this specific issue in Version 2405 (June 19 release) and subsequent updates.

Solution 2

Roll Back to a Previous Version of Office

If updating is restricted by your organization or the patch is unavailable, reverting to an older, stable version of Office is the best workaround.

Free Microsoft Office alternative

Experience Stable Spreadsheet Editing with WPS Office

If frequent Microsoft 365 updates are causing bugs and disrupting your financial workflows, consider trying WPS Office. It offers a lightweight, highly stable environment for handling complex spreadsheets without forcing disruptive background updates.

1. Download WPS Office: Navigate to the official WPS Office website and download the free software installer for your PC or Mac.
2. Install the Software: Run the downloaded installation file and follow the quick on-screen prompts to set up the office suite.
3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx workbooks directly. You can now modify your spreadsheet structures without encountering the Microsoft update bug.

Seamless compatibility with Microsoft Excel (.xlsx, .xls, .csv) formatsStable performance completely unaffected by Microsoft 365 update bugsFree to use with a familiar, easy-to-navigate interfaceLightweight application that opens large data files quickly and smoothly

microsoft office alternative - wps office

Frequently Asked Questions

Why did Excel suddenly stop letting me insert or delete rows?

This is typically caused by a known bug introduced in a recent Microsoft 365 update. The bug specifically impacts workbooks with complex setups or live data add-ins like Bloomberg, causing cell manipulation failures and incorrect formula calculations.

How do I find my current Excel version to see if I need an update?

Open Excel, click on 'File' in the top-left corner, and select 'Account' from the menu. Your version, build number, and update channel will be clearly displayed on the right side under 'About Excel'.

Will rolling back my Office version delete my files?

No. Rolling back to a previous Microsoft 365 software version only affects the application files. Your personal workbooks, data, and saved documents will remain completely intact and secure on your drive.

What if my 'Update Now' button is missing?

If the 'Update Options' or 'Update Now' buttons are missing from your Account page, it usually means your software updates are centrally managed by your company's IT department. You will need to contact them to push the latest fix to your device.

Installation & Activation