Custom Views with tables

[Tevuna]

It seems that Excel doesn't allow for the 'custom view' feature to operate in
a workbook that contains tables. Does anybody know whether this is true and
why?

 

[Jan Karel Pieterse]

Hi Tevuna,

It seems that Excel doesn't allow for the 'custom view' feature to operate in
a workbook that contains tables. Does anybody know whether this is true and
why?

I've just created a workbook (Excel 2003) with a table (Data, Table) which did
allow me to define a custom view. What exactly is your problem?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Tevuna]

Excel 2007

Hi Tevuna,


I've just created a workbook (Excel 2003) with a table (Data, Table) which did
allow me to define a custom view. What exactly is your problem?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Jan Karel Pieterse]

Hi Tevuna,

Excel 2007

Just tried with 2007 and it worked fine for me there too.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Tevuna]

Jan, thanks for replying.
Tables in Excel 2007 are the equivalents to lists in 2003; custom views seem
to be disabled in 2003 where a list is present on sheet.

 

[Jan Karel Pieterse]

Hi Tevuna,

Tables in Excel 2007 are the equivalents to lists in 2003; custom views seem
to be disabled in 2003 where a list is present on sheet.

Ah, that explains things. I thought you were referring to the "data, table"
equivalent of Excel 2003.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[malcomio]

I'm having the same problem - any ideas why custom view won't work on a sheet
with tables?