Thread: Autofilter in 2007 limits view in 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
  
Posts: 177
Default Autofilter in 2007 limits view in 2003
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?
Reply With QuoteReply With Quote