"Fixed Objects will move" pop-up freezes Excel

Anonymous
2010-08-10T19:14:50+00:00

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.

Microsoft 365 and Office | Excel | For home | Windows

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
2010-08-11T10:27:47+00:00

‘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

Was this answer helpful?

200+ people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2010-09-23T00:05:10+00:00

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

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

or

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

Was this answer helpful?

100+ people found this answer helpful.
0 comments

42 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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
  2. 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
  3. Anonymous
    2010-08-10T23:16:24+00:00

    I have not had this issue myself, but searching using Google Groups brings up mentions of cell comments which are not set to move and size with cells, the use of autofilter, and freeze panes.  None of these are obviously

    connected with saving unless you have a Workbook_BeforeSave macro that maniputlates things.

    Anyway, does anything in this thread help:

    http://www.mrexcel.com/forum/showthread.php?t=84261

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

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments