Office for Mac Issues

Fix Excel for Mac Switching Workbooks or Moving Sheets Unexpectedly

Elise Williams Sep 30, 2026 868 views

Question details

The user needs to resolve a glitch where performing an action in one open Excel workbook applies the changes to a completely different workbook.

How to Fix Excel for Mac Switching Workbooks or Moving Sheets Unexpectedly

Product: Excel for Mac
Device & OS: macOS
Scenario: Working with multiple open workbooks simultaneously and performing routine tasks like selecting tabs, pasting data, or inserting rows.
Observed behavior: Actions intended for the active workbook unexpectedly affect another open workbook, or sheets move randomly. This behavior persists even after reinstalling Microsoft Office and booting macOS in Safe Mode.

Before you start

Verify your exact Excel version by navigating to Excel > About Excel in the menu bar, and temporarily close all non-essential workbooks to prevent unintended data overwrites while testing.

Solution 1Recommended

Test Excel in a New macOS Local User Account

Since Safe Mode and reinstallation did not resolve the problem, testing in a new user account will determine if your current macOS user profile or its preference files are corrupted.

Microsoft Office relies on specific configuration files stored within your macOS user account. When these files become damaged, they can cause window management and workbook targeting issues that a standard reinstallation cannot fix.

Open System Settings

Click the Apple menu in the top-left corner of your screen and select 'System Settings' (or 'System Preferences' on older macOS versions).

Create a New User

Navigate to 'Users & Groups', click 'Add Account', authenticate with your admin password, and set up a new standard or administrator local user.

Log In to the New Account

Log out of your current macOS session and log back in using the newly created user credentials.

Test Excel Behavior

Launch Excel for Mac, open multiple workbooks, and perform actions like inserting rows or pasting data to see if the switching issue persists.

Test Excel in a New macOS Local User Account

Profile Diagnostics: If Excel works perfectly in the new account, the issue is isolated to your original profile. You will need to migrate your files to the new account or repair the old profile's system files.

Solution 2

Migrate Office Settings to the New User Account

If creating a new user account resolves the issue, safely transfer your custom Office templates and user content from the corrupted profile to the working one.

Free Microsoft Office alternative

Try WPS Office for Mac for a Stable, Glitch-Free Spreadsheet Experience

If Microsoft Excel continues to act unpredictably and corrupt macOS user profiles, WPS Office offers a free, lightweight, and highly stable alternative. It seamlessly handles multiple spreadsheets in a unified tabbed interface without unexpected workbook switching.

1. Install WPS Office: Download and install the free WPS Office application for Mac.
2. Open Your Workbooks: Double-click your existing .xlsx files to open them seamlessly in WPS Spreadsheets.
3. Manage Multiple Files: Use the stable, built-in tab system to switch between workbooks and edit data safely without overlap errors.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Reliable tabbed interface that manages multiple open workbooks flawlessly.Lightweight architecture that consumes fewer macOS system resources.Familiar layout with zero learning curve for existing Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my actions in one Excel workbook apply to another on Mac?

This glitch typically happens due to corrupted user-level preference files or macOS user profile damage, which causes Excel's window management system to misdirect your commands to the wrong background window.

Will reinstalling Microsoft Office fix workbook switching bugs?

Not always. A standard uninstallation does not remove hidden user data inside the Mac Library folder. If the bug stems from a corrupted configuration file in your user profile, reinstalling the app will not solve the issue.

Where are my custom Excel templates saved on a Mac?

Your personalized Excel templates and user content are stored in a hidden system folder located at Library/Group Containers/UBF8T346G9.Office/User Content.localized.

Office App Problems