Custom Views for an Excel Table?

[ruud1010]

I have an Excel Table, created via an ODBC Connection that I frequently refresh, whereby I imported multiple text files into the single Excel Table. The Custom Views icon is greyed. Does this mean this feature is not available for use in tables? I would like to save several filter and hidden column settings. If Custom Views is not available for tables, would the next best thing be to create macros to set these views? I am running Excel 2007.

 

[Andrew Poulsom]

According to this:

http://office.microsoft.com/en-us/excel/HP012170451033.aspx

if any worksheet in the workbook contains an Excel table, the Custom Views command will not be available anywhere in the workbook.

So I'm afraid you will have to find an alternative.