Custom Views with tables

G

Guest

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

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?
Click to expand...

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
 
G

Guest

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.
 
J

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.
Click to expand...

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
 
M

malcomio

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

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

Similar Threads

Tables and Custom views in Excel 2007 1
XL 2007 Custom Views - Print Settings Option 3
Display columns or rows based on values 1
Custom View Bug? 7
Custom Views in Shared workbook 1
Custom Views 1
Can you copy custom views to another workbook? 1
Custom views in excel keep changing 2

Top