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.
This is a confirmed issue in Microsoft Excel 2010 and 2013. Microsoft is currently investigating the cause.
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
2. Save the workbook in Excel 2007-2010 format (XLSX, XLSM, XLSB).