Forum Discussion
Excel Error "Fixed objects will move."
Same issue is persisting office 10, its very serious issue when I am working with filter function and same time this error encountered.
Now if i reopen workbook & now neither filter remove nor any action take place.
As some suggestion suggested like "Ctrl + G> select object>......" not in working.
If any can resolve this, Please do without loss of data.
This is temporary solution for this type of error:
If you notice that A circular reference showing in left side downward of worksheet like "Circular reference AH5834", this reference is your objects location which may be visible or may be hidden with filter (you cannot reach there), if try to reach there than error showing "fixed objects will move".
In that case we have to delete the column reference first without clearing filter, after that clear the filter once error message shows than click on ok, now excel working in normal.
In last If you want that important column than press 2 times ctrl+Z wait for response, again clear filter, click on ok on error message, now you retrieve your original data.
Now you can fixed your problem using function of Ctrl + G > special > Object and delete all objects/ Invalid references save the excel.