Custom Views Greyed Out

[Guest]

Custom Views is greyed out in my spread sheet. Somewhere during the
development I put in two custom views that I cannot activate or delete. Any
ideas on what can cause this. I only have one spread sheet selected.
Thanks,

Jerry B

 

[Guest]

I have the same issue. The custom views option is grayed out and I have no
way to use this funtion now. Need help here!

 

[Gord Dibben]

Do you have more than one worksheet selected? Do you see [group] up on the
title bar?

That will gray out Custom Views.

Right-click on a sheet tab and "ungroup".


Gord Dibben Excel MVP

 

[Guest]

That is not the case. I would be very happy to email this to you if you
would like. I have been struggling for hours on this.
--
Wayne

Do you have more than one worksheet selected? Do you see [group] up on the
title bar?

That will gray out Custom Views.

Right-click on a sheet tab and "ungroup".


Gord Dibben Excel MVP

I have the same issue. The custom views option is grayed out and I have no
way to use this funtion now. Need help here!

 

[Guest]

Hi:
I traced my problem down to "Lists" being in the spread sheet. As soon as I
removed them, custom views became available again. I hope this works for
you.