"Fixed Objects will move" pop-up freezes Excel

Anonymous

Spreadsheet opens and I can navigate for awhile and, for example, when I go to save the sheet the message pops up: Fixed Objects Will Move. This freezes Excel and I use Task Mgr to "END" the Excel program

This spreadsheet was used for ten months, add a column per month in Excel 2007 - now, possibly since installing Excel 2010, I get this message. I haven't noticed it in other spreadsheets.

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.

0 comments

Answer accepted by question author

Anonymous

‘Fixed objects’ in Excel may refer to multiple items, such as comments, graphics, controls, etc. Do you recall inserting any fixed object in the Excel sheet? Try the following steps: Note: Ensure to back-up the original file prior to performing the steps given below.

1) Search the objects in the worksheet by pressing ‘F5’ to display the ‘Go To’ dialog box

2) Click on ‘Special’ and select the ‘Objects’ radio button then click on OK

3) This will select all the objects in the Excel sheet, you may delete them and verify the status

0 comments

Answer accepted by question author

Anonymous

cell comments are not treated as Objects by Goto > Special > Objects

Use Tools > Options > View > Comments: Comments and Indicator (2003 or earlier)

Review > Show All Comments (2007 or later)

and you will be able to see where the comments are.

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

0 comments

42 additional answers

Anonymous

2012-04-19T14:38:57+00:00

I am using Office 2010 and THIS suggestion is the only one that worked. I only deleted "Comments and Annotaions" and this was effective in removing the "Fixed Objects..." annoying message that kept locking the Excel program. Thank you.
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments
Anonymous

2012-07-05T12:57:30+00:00

This did the trick-Thanks
Was this answer helpful?

1 person found this answer helpful.

0 comments No comments
Anonymous

2013-06-18T21:38:20+00:00

Mar18519

Check your "options" (look under the file tab) in Excel 2010.

Click on "advanced" and make sure that "Cut copy and sort inserted objects with their parent cells" is checked.

I checked that box and it solved my problem.

It's wierd, because it only happens with some spreadsheets, not others (me to)

Worked of me

Thanksyou

this is the answer at the problem

Sub CommentsMoveAndSize()

'// Written by Greg Truby, July 2006

'//

'// If a large worksheet has comments and you

'// attempt to apply AutoFilter, sometimes Excel will

'// start telling you "Fixed objects will move."

'//

'// Per the kb article here:

'// «« http://support.microsoft.com/default.aspx?id=211769 »»

'// this routine fixes it.

'//

'// [Tested on a worksheet with 5,000 rows × 150 columns

'// and 1,796 comments. Also tested on shared workbooks,

'// and protected worksheets. Neither raised an error.]

    Dim cmtEach As Comment

    If ActiveSheet.Type <> XlSheetType.xlWorksheet Then

        MsgBox "What are you? Daft?" & vbCr & vbCr & "Pick a worksheet.", _

                vbExclamation, "Bad Sheet Selection"

        Exit Sub

    ElseIf ActiveSheet.Comments.Count = 0 Then

        MsgBox "There are no comments on the active sheet.", vbInformation, "I Have No Comment"

    Else

        '// Change each comment to "move and size with cells"

        For Each cmtEach In ActiveSheet.Comments

            cmtEach.Shape.Placement = xlMoveAndSize

        Next cmtEach

    End If

End Sub

Thks to Greg the person that help us http://www.mrexcel.com/forum/excel-questions/84261-fixed-objects-will-move.html
Was this answer helpful?

4 people found this answer helpful.

0 comments No comments