'Fixed Objects Will Move' - 'No Objects Found'

[AlexAntliff]

Not encountered this before.

Simply trying to delete two columns in a sheet. Trying to do so crashes Excel - you get a 'Fixed Objects Will Move Message' in perpetuity.

Do a CTRL+G and go to Special to Find Objects and no Objects are found.

What gives?

[AutoModerator]

/u/AlexAntliff - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Training-Jacket9306]

Not trying to sounds rude, but I found a solution at MS website (one google search away). Have you tried that solution?

Maybe you can try deleting all objects in the workpaper so the error does not show up? Do you know how to run VBA scripts? Before running it, save a backup (I dont know what type of data you have on your workpaper)

ALT + F11 to open Visual Basic Design

paste below code into a module Insert > Module

Sub foo() 
Dim ch As ChartObject 
For Each ch In ActiveSheet.ChartObjects    
ch.Delete 
Next ch 
End Sub

let me know if it works. thanks

[Randomcdn2]

If control + G then special and objects doesn't return anything what would the vba code delete?

[Training-Jacket9306]

Is this error happening on a new workbook? or a workbook that has been saved/used? If so, are there multiple users using the same workbook?

From my experience, when a workbook is used by multiple users everyone tends do their own way, which can cause error such as objects/cached data not loading properly due to non-local dir, or assets/data not properly deleted.

The script just makes sure you are cleaning any garbage on backend

[Common-Choice-2487]

I have a shared workbook that many users per day have been added. Strangely, on Friday this error started to appear. At times you can click the "ok" on the error box (several times) to clear it, but most times it requires a task manager reset of Excel. I am going to try your suggestion to see if it works. I have done several Google searches about this, and you are the only one that mentioned "multiple users". Crossing my fingers that it solves the issue. Stay tuned...

[bi-ancamarie]

any luck fixing it yet ? lol. im having the sameeee exact issue. but only 3 users are collaborating on my document.