"Fixed objects will move" notice comes up repeatedly when filtering a range

Article ID: 2601322 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Consider this scenario: You open an Excel 97-2003 format file in Excel. The file contains a table area with autofilter applied. The table area contains cell comments. When you attempt to filter the range, you receive the message, "Fixed objects will move." You click OK, but the message comes up again and again before Excel finally filters the table range.

Cause

This is a confirmed issue in Microsoft Excel 2010 and 2013. Microsoft is currently investigating the cause.

Resolution

There are two possible workarounds for this issue:

1. If you need to keep the file in Excel 97-2003 format, change the comments' properties to move and size with cells. The following macro will set all comments in the workbook to move and size with cells:

Dim wksht As Excel.Worksheet
Dim wb As Excel.Workbook
Set wb = ActiveWorkbook

    For Each wksht In wb.Worksheets
        For Each cmt In wksht.Comments
           cmt.Shape.placement = xlMoveAndSize
        Next cmt
    Next wksht

End Sub

2. Save the workbook in Excel 2007-2010 format (XLSX, XLSM, XLSB).
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2601322 - Last Review: October 31, 2012 - Revision: 2.0
Applies to
  • Microsoft Excel 2013
  • Microsoft Excel 2010
Keywords: 
KB2601322

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com