Document Editing Problems

Fix Excel Inserting Blank Columns Beside Hidden Columns

Maira Mehtab Sep 24, 2026 871 views

Question details

Users experience an issue where Excel repeatedly and automatically inserts blank columns adjacent to hidden columns in a workbook shared via Microsoft Teams.

Product: Microsoft Excel, Microsoft Teams
Device & OS: not provided
Scenario: Coauthoring, syncing, or editing a shared workbook containing hidden columns in a Microsoft Teams channel.
Observed behavior: Blank columns are unexpectedly generated next to hidden columns, potentially due to synchronization glitches, workbook defects, or active macros.

Before you start

Create a local backup copy of your affected workbook before troubleshooting to ensure no data is lost during testing.

Solution 1Recommended

Isolate the Workbook Issue and Check Active Elements

Test the workbook in different environments and disable automated elements to see if the issue stops.

The automated insertion of columns can be triggered by synchronization conflicts during coauthoring, corrupted pivot tables, or macros.

Testing the file in different Excel environments helps narrow down the root cause.

Test in Excel for the Web

Navigate to your Microsoft Teams channel, find the affected workbook, click the three dots next to the file, and select 'Open in browser' to see if the issue persists online.

Test in the Desktop App

While viewing the file in Teams or the browser, click 'Open in Desktop App' to determine if the local Excel client causes the column insertion.

Check Macros and Connections

Open the 'Developer' tab to inspect for active macros, and go to the 'Data' tab to review external connections or add-ins that might be modifying the sheet's structure.

Monitor Coauthoring Activity

Have other users temporarily close the workbook to isolate whether real-time synchronization and coauthoring are triggering the bug.

Solution 2

Open a Microsoft Support Service Request

If troubleshooting does not resolve the issue, Microsoft Support will need to inspect the tenant logs for deeper bugs.

Free Microsoft Office alternative

Try WPS Office for Stable Spreadsheet Editing

If synchronization bugs and unexpected formatting issues in Microsoft Excel disrupt your workflow, consider switching to WPS Office. It is a lightweight, reliable, and highly compatible alternative that handles complex spreadsheets with ease.

1. Download WPS Office: Visit the official WPS website to download the free WPS Office suite for your device.
2. Install and Launch: Run the installation file and launch the WPS Spreadsheet application.
3. Open Your Workbooks: Open your existing .xlsx files directly in WPS Spreadsheet and edit them seamlessly without worrying about hidden column bugs.

Seamless format compatibility with Microsoft Excel (.xlsx and .xls) filesFree to use with a familiar, easy-to-navigate user interfaceStable performance that prevents unexpected column insertions or formatting glitchesLightweight installation for fast file loading and processing

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel insert blank columns on its own?

This is often caused by synchronization errors during coauthoring in shared environments like Microsoft Teams or SharePoint, corrupted workbook data, or conflicting macros that automatically adjust sheet layouts.

Can pivot tables cause columns to be inserted next to hidden ones?

Yes. When a pivot table or external data connection refreshes, it may expand to accommodate new data. If the layout overlaps with hidden columns, Excel may insert blank columns to prevent data overlap.

How do I find out who my Microsoft 365 administrator is?

In most organizations, your Microsoft 365 administrator is a member of your IT department, the person who issued your work email account, or a technical support manager.

Document & File Issues