Data Import & Export

Fix Excel Overwrites Cells When Refreshing External Data

Ayan Masood Sep 27, 2026 868 views

Question details

The user is experiencing an issue where Excel overwrites existing data cells when refreshing an external data connection, and the specific setting to prevent this keeps turning off.

How to Fix Excel Overwriting Cells When Refreshing External Data

Product: Microsoft Excel / Microsoft 365
Device & OS: not provided
Scenario: Refreshing external data connections in a shared or organizational workbook.
Observed behavior: Excel refreshes data directly over existing cells because the overwrite option unexpectedly becomes disabled, often affecting multiple users across an organization due to a software update.

Before you start

Before attempting to refresh your data or troubleshoot connection properties, create a secure backup copy of your workbook to prevent any permanent data loss from accidental overwrites.

Solution 1Recommended

Report the Update Bug via Microsoft 365 Admin Center

Since this behavior is frequently linked to a recent Microsoft 365 or Excel update affecting multiple users, escalating the issue to IT or Microsoft Support is the most effective resolution.

When the 'overwrite existing cells' option keeps becoming disabled independently, it is usually a bug introduced by a recent Office patch rather than user error.

Because this impacts the core functionality of external data properties, standard local troubleshooting may not permanently resolve it until Microsoft releases a fix.

Review Update History

Check the Microsoft Office update history on your device to see if a recent patch release coincides with the onset of the data refresh issue.

Test with a Backup

Open a backup copy of the workbook, navigate to Data > Connections > Properties, and attempt to manually re-enable the correct overwrite setting to see if the issue persists upon the next refresh.

Open a Support Request

Ask your Microsoft 365 administrator or IT department to log into the Microsoft 365 admin center and open an official support request so Microsoft can investigate the service issue.

Report the Update Bug via Microsoft 365 Admin Center

Organization-wide issue: If multiple users in your company are experiencing this exact data overwrite bug simultaneously, it is highly likely a systemic update issue that requires an administrative ticket.

Free Microsoft Office alternative

Try WPS Office for Reliable Data Management

If Microsoft Excel updates are disrupting your workflow and causing unexpected data overwrite issues, consider switching to WPS Office. It is a lightweight, highly compatible, and free alternative that handles complex spreadsheets effortlessly without the bloated update bugs.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open WPS Spreadsheet: Launch the WPS Spreadsheet application from your desktop or start menu.
3. Import Your Excel File: Click 'Open' to safely load your existing Excel workbook and continue managing your data securely.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Stable data import and spreadsheet management features without unexpected overwrite bugs.Familiar user interface allowing for a seamless and immediate migration.Completely free and lightweight, minimizing system resource usage.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the 'Overwrite existing cells' option keep disabling in Excel?

This is a known behavior that often surfaces after certain Microsoft 365 updates, causing Excel to forget the saved property settings for external data connections and default to overwriting adjacent cells.

Can I prevent external data from overwriting adjacent columns?

Normally, you can right-click the data range, select 'Data Range Properties', and choose the option 'Insert cells for new data, delete unused cells'. If this setting disables automatically, you are likely experiencing a software bug requiring a patch.

Does WPS Spreadsheet support external data imports?

Yes, WPS Spreadsheet supports importing data from text files, CSVs, and other external sources, providing stable property settings to manage how new data fits into your existing sheet.

How do I rollback a Microsoft Office update to fix this bug?

You can revert to an earlier version of Office using the Office Deployment Tool or by executing specific command-line prompts, but this process should typically be managed by your organization's IT administrator.

Excel & Data Problems