Autofilter in 2007 limits view in 2003

R

RFP330

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?
 
L

~L

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?
 
R

RFP330

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

~L

If resizing the columns is okay, you can add:

Cells.Select
Cells.EntireColumn.AutoFit
Range("A1").Select

to your macro.

As for the cause, somehow the contents are changing width. It seems
unlikely, but perhaps there is a font in 2007 that is not present in 2003 and
the font 2003 is defaulting to is wider than the one used in 2007.

It may also be a difference in program option settings.
For example, in 2007 under options in the advanced/general section, there is
an item for "Scale content for A4 or 8.5 x 11" paper sizes. Unchecking this
on the computer you are saving the document on wouldn't help (except to maybe
make your cell contents not fit the width) because any settings under these
options are for your instance of Excel.

Any of that helpful?
 
R

RFP330

Thanks. This sounds like it will work. As for the font, it's Arial, so it
should not be an issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top