File...Options...Advanced. In the "Cut copy and paste" area, remove the tick for "Cut, copy and sort inserted objects with their parent cells"
Richard ButtreyRIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
- 06-17-2021, 01:27 PM Forum Contributor
Re: Fixed Objects Will Move
-Thanks, but I do not have that box checked.
- 06-17-2021, 02:53 PM
Re: Fixed Objects Will Move
What objects do you have in the workbook? Sometimes they're not immediately obvious. I've know of pictures being reduced to a single pixel space. Upload the workbook so that we can see the problem in context. Although I've never encountered it, it seems to have a long history, back to at least Excel 97-2003. Mỹ Duyên10114311 nói:
Mọi người cho em hỏi e đang làm file excel và đang filter hàng hóa thì bị lỗi " Fixed objects will move" ạ. file khá nặng tại em làm thông tin hàng hóa của 1 năm lận ạ Anh chị biết cách nào khác phục chỉ giúp em với ạ
Nhấn để mở rộng... Có thể bạn copy dữ liệu từ phần mềm sang nên trong File của bạn có quá nhiều Object hay hình ảnh [bị ẩn]. Cách tốt nhất là đính kèm File mới biết được nó là cái gì để chữa trị, vì File chậm chạp hay nặng nó có rất nhiều nguyên nhân nên không thể đoán mò được. Due to some unwanted errors, an Excel file freezes, and consequently, while saving the file an error message pops up like “Fixed Objects Will Move”. Nothing works unless you open the Task Manager and hit End to stop the program. In this article, you will get 4 solutions to fix the “Fixed Objects Will Move” error in Excel.
-What Are Fixed Objects in Excel?
Fixed Objects are those objects that Excel keeps fixed in a specified position. The common fixed objects in Excel are comments, graphics, controls, etc.
What Is the “Fixed Objects Will Move” Error in Excel?
The “Fixed Objects will Move” is such an error that freezes the Excel file. For some unwanted errors, it may occur. If this error occurs, then you will see an error message “Fixed Objects will Move” appear while saving the file. You may end up clicking on OK to solve the problem but this never goes away unless you use the Task Manager to terminate the program.
-How to Fix “Fixed Objects Will Move” Error in Excel: 4 Solutions
1. Save Excel Files as XLSX or XLS Files to Fix “Fixed Objects Will Move” Error
To fix the problem “Fixed Objects will Move” inspect your worksheet for error and then save the file as an xlsx or xls file. To do so, here are the steps to follow: ❶ First go to the File tab.
2. Find and Remove All the Objects from Excel Worksheet to Solve the “Fixed Objects Will Move” Error
If you can detect all the fixed objects and then delete them as they were causing the issues, you can fix the issues easily. Now follow the steps below to learn how to detect and delete them. ❶ Press CTRL + G to open the Go To dialog box. ❷ Click on the Special button.
3. Enable “Don’t Move or Size with Cells” to Repair the “Fixed Objects Will Move” Error in Excel
If you have inserted some graphics in your Excel workbook and suspect them of causing the “Fixed Objects will Move” problem, then do the following: ❶ Click on an individual graphic image that you have inserted. ❷ Go to the Picture Format tab. ❸ Under the Size group, you will find the Size and Properties icon at the right-bottom corner. Just click on it to expand.
4. Use Visual Basic Script to Fix “Fixed Objects Will Move” Bug in Excel
You can use the following VBA script to solve the “Fixed Objects will Move” error in Excel. For that, ❶ Press ALT + F11 to open the VBA editor. ❷ Go to Insert > Module.
Sub HandleErrors[]
Dim x As Excel.Worksheet
Dim y As Excel.Workbook
Set y = ActiveWorkbook
For Each x In y.Worksheets
For Each cmt In x.Comments
cmt.Shape.Placement = xlMoveAndSize
Next cmt
Next x
End Sub
❹ Paste and save the above code in the VBA editor.
Things to Remember
Press CTRL + G to open the Go To dialog box. To open the VBA editor, press the ALT + F11 button.- To run a VBA code in Excel, press the F5 key.
-
Download Practice Workbook You can download the Excel file from the following link and practice along with it.
-Conclusion
To sum up, we have discussed 4 methods to fix fixed objects that will move in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.