4 Solutions to Fix Fixed Objects Will Move Error in Excel

Like other programs, Excel sometimes faces errors and crashes too. One of such errors is “Fixed Objects Will Move” error. When this error occurs, the Excel spreadsheet freezes and becomes unable to be used. We have to completely close the program and start over. This article will talk about the ways in which we can fix “Fixed Objects Will Move” error in Excel.


📁 Download Excel File

Download the practice workbook below.


Overview of Fixed Objects Will Move Error in Excel

The error with the name “Fixed Objects Will Move” occurs sometimes when we want to close an Excel file where the program freezes and cannot be made functional again without quitting the program. Often, we need to bring in the Task Manager and End the task to get rid of the frozen programs screen. This error can occur due to incorrect usage of Excel formulas and commands or software-related issues.


Learn to Fix Fixed Objects Will Move Error in Excel with These 4 Suitable Solutions

For fixing the error named “Fixed Objects Will Move,” we can look for various steps depending on the cause. We have made a summary of the possible ways to get rid of such an error. Following any one of these steps might to the trick. The steps are discussed below.


Solution

1. Finding and Removing All Objects from Worksheet

We need to find fixed objects at first and delete them in order to avoid “Fixed Objects Will Move” error. To do this, we follow these steps:

⬇️⬇️ STEPS ⬇️⬇️

  • At first, we enter Go To box by pressing the shortcut key Ctrl+G.
  • Then we select Special option.

  • A new Go To Special box will appear. We pick Objects from popped up list and press OK.

  • Now all fixed objects will be selected. Finally, we press Delete button so that we can delete such fixed objects.

how to fix fixed objects will move in excel by finding and removing all objects

  • In this way, the error will be solved.

Solution

2. Enabling Move and Size with Cells Option

The error might occur due to any graphic content present in the spreadsheet. If we can assume that such a graphic is causing our problem, we need to follow this approach. The steps for this approach are as follows:

⬇️⬇️ STEPS ⬇️⬇️

  • In the beginning, we select a graphics or an image present in the Excel file.
  • Then we move on to Picture Format segment under Size section of the Ribbon.
  • We click on Size and Properties icon present at bottom right of that Ribbon and expand the menu.

  • We expand the Properties section from Format Picture popup menu.
  • In the Format Picture menu, we head over to Properties section and select Move and size with cells.

how to fix fixed objects will move in excel by enabling Move and size with cells

  • Thus, this is a probable solution to getting rid of “Fixed Objects Will Move”

Solution

3. Saving Files in XLSX or XLS Format

In this approach, we will inspect the file for possible sources of errors and then save them in the XLSX or XLS format. This approach also might get rid of the problem depending on what’s causing it. The steps for this approach are as follows:

⬇️⬇️ STEPS ⬇️⬇️

  • At first, we go to File tab.

  • Then we click on Info.

  • Next, we select Inspect Document from the Check for Issues option.

  • A popup message will appear asking us if we want to save the Excel file or not. We click on No as we have to save it after inspection of errors.

  • Right after that, a document inspection will take place and a window named Document Inspector will come out. We click on the Inspect button to do our task.

  • When all the selected contents are checked most of them will turn into green ticks. Then we press the Close button.

  • Then we go to Save As option by going back.

  • From the Save as type box, we select the format .xlsx or .xls from the drop-down list.

how to fix fixed objects will move in excel by saving files in xlsx or xls format

  • Finally, the file will save and we will get rid of the said warning.

Solution

4. Inserting VBA Code

VBA Codes and scripts are easier ways of solving such problems especially when the dataset is large and complex. The steps for writing this script are as follows:

⬇️⬇️ STEPS ⬇️⬇️

  • We go to Developer tab and select Visual Basic. Alternatively, we can press the shortcut Alt+F11 in order to open Visual Basic editor.

  • Next, we insert a new module.

  • Then we write this given Code.
Sub FixErrors()
Dim s As Excel.Worksheet
Dim b As Excel.Workbook
Set b = ActiveWorkbook
For Each s In b.Worksheets
For Each cmt In s.Comments
cmt.Shape.Placement = slMoveAndSize
Next cmt
Next s
End Sub
  • Then we press the Run button or F5 key as a shortcut.

how to fix fixed objects will move in excel by inserting VBA code

  • Thus, the problem will be solved using this approach of VBA Code.

Other Conventional Solutions to Fix Fixed Objects Will Move Error in Excel

Sometimes, the root cause of errors such as the one being described lies in very simple steps. For restarting a machine can reload its system again and might remove existing errors or an older version of a program might cause errors on software. So, we must take a look at these conventional steps as well. We have discussed them briefly below.

Solution

1. Restarting Computer

If we encounter problems such as this, we can simply restart the computer. What this restart does is that it reloads the system again for a fresh start and removes any error that might have been stuck unresolved during the process. The steps in which we can restart our computer are as follows:

⬇️⬇️ STEPS ⬇️⬇️

  • We select the Windows option from the bottom left corner of our Start Bar or by pressing the Windows key on our keyboard.
  • We hover over to the Power Options tab and select Restart.

how to fix fixed objects will move in excel by restarting computer

  • We can restart alternatively by pressing the shortcut Alt+F4 and then a popup window will appear. We can select Restart from there and press OK.

Solution

2. Updating Microsoft Excel

Sometimes, the version of Office can be solely responsible for some errors. So, updating our existing Office suite to a newer version can also do the trick for some problems. The steps to update Excel are as follows:

⬇️⬇️ STEPS ⬇️⬇️

  • We go to File tab at first.

  • Then we go to Account section.

  • Then we click on the Update Options tab and click on Update Now.

how to fix fixed objects will move in excel by updating Microsoft Office

  • We can also Enable updates to automatically take an update when available.

📄  Important Notes

🖊️  We can press the shortcut key Ctrl+G in order to open Go To box quickly.

🖊️  The shortcut Alt+F11 opens the Visual Basic editor quickly and to run the code, we can use the shortcut F5 key.


📝  Takeaways from This Article

You have taken the following summed-up inputs from the article:

📌  We can use the Go To box to detect all fixed objects and press Delete to get rid of such objects.

📌  By Enabling Don’t move or size with cells, we can get rid of fixed objects especially any sort of graphical content.

📌  We can inspect and save a file and also alternatively write a VBA Code to get rid of such an error.

📌  A quite simple way of fixing such an error issue is to restart our computer or remain updated with the operating system software.


Conclusion

In conclusion, I hope that this article has provided you with insights about how we can fix “Fixed Objects Will Move” in Excel. If you want to know more about Excel, please visit our site ExcelDen and if you have any queries regarding this topic, feel free to let us know down below in the comment section.

(Visited 33 times, 1 visits today)
Abrar

Abrar

Hello there! I am Mohammad Abrar Uddin, an engineering graduate from BUET. I write articles and blogs related to Excel in this site and hope that the viewers can learn simple to complex solutions of Excel problems easily by reading such articles.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo