This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When I try to 'clear' a filter I get this annoyingly stubborn message 'Fixed Objects will Move'
The error message continues to appear. I click on 'OK' many times but the message does not go.
All my work is stuck!
What do I do?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hello! From Main Excel Menu: Options\Advanced and in the "Cut, copy and paste" area remove the tick for "Cut, copy and sort inserted objects with their parent cells!
No personal experience with this issue here, but it's been said that it may be linked to the freeze panes option. Try to un-freeze panes and apply filters to see if the error does not occur.
hth
Vaya con Dios,
Chuck, CABGx3
The only thing is to accept the dialog message till it disappears.
have tried all these and still stuck with this annoying window..
Thanks for the heads-up
Using Office 365 (2016) had this issue, had not used "Freeze Frames" on the sheet in question myself, but perhaps some else did (its shared). I turned "Freeze Frames" on and then off again and it cleared the issue.