It displays if the column width is expanded.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 10/15/2007
'
' Keyboard Shortcut: Ctrl+r
'
ActiveWindow.FreezePanes = False
Rows("2:2").Select
Selection.AutoFilter
Selection.AutoFilter
Range("J3").Select
ActiveWindow.FreezePanes = True
Range("A3").Select
End Sub


"~L" wrote:

Do you mean the data that overruns the width of the column is lost, or does
it just not display (even when you resize the colum)?

Would you mind posting the macro code?

"RFP330" wrote:

I set an autofilter in an Excel 2007 using a macro and then manually save the
sheet as Excel 97-2003. The filter data is limited to the width of the
column for users of Excel 2003. Is this a compatibility issue or is there a
setting I need to change?