Contact us

Fix: “Fixed objects will move” Error in Microsoft Excel

Microsoft Excel logo

An accounting firm contacted us because a key Excel spreadsheet would not open properly. Every time they tried to launch the file, a warning dialog appeared saying “Fixed objects will move” and the spreadsheet became unresponsive, requiring them to force-close Excel through Task Manager. The issue affected multiple users on their Remote Desktop Server (RDS) environment and had been occurring intermittently across several Excel files. Here is what we found and how to fix it.

Symptoms

When opening a specific Excel workbook, the following warning appears:

Fixed objects will move.

After clicking OK on the warning, Excel becomes unresponsive and the file fails to load. The application must be terminated via Task Manager. You may also experience:

  • Excel freezing or hanging after the warning dialog appears
  • The error appearing on multiple workbooks, not just one file
  • The file opening successfully in Excel Safe Mode but failing in normal mode
  • The error persisting even after copying the file to a new location or saving it in a different format (.xlsx)

Affected Software

  • Application: Microsoft Excel (Microsoft 365 / Office 365)
  • Platform: Windows (including Remote Desktop Server environments)
  • Related Services: OneDrive for Business, Excel for the web

Microsoft Excel error dialog showing Fixed objects will move warning message

Cause

The “Fixed objects will move” error occurs when Excel detects a conflict between embedded objects (such as charts, images, form controls, comments, or shapes) and the worksheet layout. This is commonly caused by:

  • Corrupted embedded objects within the workbook that Excel cannot render properly
  • Hidden or zero-sized objects that have become orphaned through repeated edits, copy-paste operations, or version upgrades
  • Legacy .xls format issues where objects saved in the older Excel format do not convert cleanly
  • Add-in conflicts that inject objects into the workbook structure

When Excel encounters these corrupted objects during the file load process, it displays the warning and can become stuck in a loop trying to reposition them, causing the application to freeze.

Resolution

Try each method in order. The first is the quickest fix, while later methods address deeper corruption.

This is the fastest and most reliable fix. Excel for the web strips out corrupted objects and re-renders the file cleanly.

  1. Upload the affected Excel file to OneDrive for Business or a SharePoint document library
  2. Open the file in Excel for the web (click the file in OneDrive and select Edit in Browser)
  3. Verify the data looks correct in the browser
  4. Click File > Save As > Download a Copy to save a fresh copy to your computer
  5. Open the downloaded copy in the desktop Excel application to confirm the error is resolved
  6. Replace the original file with the cleaned copy (keep a backup of the original just in case)

Method 2: Open in Safe Mode and Remove Objects

If you cannot use Excel for the web, try cleaning the file manually.

  1. Press Win + R, type excel /safe and press Enter to launch Excel in Safe Mode
  2. Open the affected workbook
  3. Press Ctrl + G (Go To) > click Special > select Objects > click OK
  4. If any objects are selected, press Delete to remove them
  5. Also check the Selection Pane (Home > Find & Select > Selection Pane) for hidden objects
  6. Save the file and try opening it normally

Method 3: Open and Repair

  1. Open Excel (do not open the file directly)
  2. Click File > Open > Browse to the affected file
  3. Click the dropdown arrow next to the Open button and select Open and Repair
  4. Click Repair to attempt recovery, or Extract Data if repair fails
  5. Save the repaired file with a new name

Method 4: Repair the Office Installation

If the error affects multiple files, the issue may be with the Excel installation rather than individual workbooks.

  1. Open Settings > Apps > Installed apps
  2. Find Microsoft 365 Apps, click the three dots, and select Modify
  3. Choose Online Repair and follow the prompts
  4. Restart your computer after the repair completes

Important Notes

  • Always back up the original file before attempting any fix
  • If the file opens in Safe Mode but not in normal mode, the issue is likely related to add-ins or corrupted objects rather than file-level corruption
  • Files in the older .xls format are more prone to this error. Consider converting to .xlsx after cleaning
  • In RDS or shared desktop environments, ensure all users close the file before attempting repairs

If you need help resolving Excel errors or file corruption issues, get in touch with our team.

Was this article helpful?
Yes No

About The Author

Elliot Munro building AI automation solutions at GCIT
Elliot Munro
Elliot Munro is GCIT's Chief Information Security Officer and leads GCIT's security and AI work. He holds Anthropic's Claude Certified Architect - Professional credential and is Microsoft Certified as a Cybersecurity Architect Expert, Microsoft 365 Administrator Expert, Identity and Access Administrator Associate and Security Operations Analyst Associate. Read Elliot's profile.
Ready to secure and simplify your IT? Talk to a GCIT expert today.
Sales 0755 999 999 Book a free consultation