Custom Views Greyed Out

J

Jerry B

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
 
W

Wayne @Micros

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!
 
G

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
 
W

Wayne @Micros

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


Gord Dibben said:
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!
Click to expand...
Click to expand...
 
J

Jerry B

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