Custom Views Greyed Out

[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

[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!
--
Wayne


"Jerry B" wrote:

> 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

[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

On Thu, 28 Apr 2005 04:48:06 -0700, "Wayne @Micros"
<[email protected]> wrote:

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

[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" wrote:

> 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
>
> On Thu, 28 Apr 2005 04:48:06 -0700, "Wayne @Micros"
> <[email protected]> wrote:
>
> >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!
>
>

[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.
--
Jerry B


"Wayne @Micros" wrote:

> 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!
> --
> Wayne
>
>
> "Jerry B" wrote:
>
> > 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

[buzzy]

Look I'm sorry about this, but I have been workinh with Excel for some time now together with a lot of other Microsoft software and one thing I have learnt is BE SPECIFIC !!! What do you mean lists ??? lists what ??? nowhere can I find in the menus 'LISTS' where are your magical 'LISTS'

[buzzy]

And why do these threads just peeter out without any conclusive resolution??? Five years on and we still have 'custom views greyed out' what a waste of time some bloggs turn out to be.

[NBVC]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

That thread is from 2005... before 2007.

In 2005 it is in Data|List

in 2007 it is now called Table from Insert menu

[buzzy]

What do you mean Gord, sheet tabs?????? the ones at the bottom of the sheet with the sheet name?? If you right click on one of these you get - 'insert' 'delete' 'rename' 'move or copy' 'read code' 'protect sheet' 'tab colour' ' hide' and 'select all sheets' BE SPECIFIC !!!! WHAT TABS ???????????

[NBVC]

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

I told you the thread is old.. Gord does not post here. Please stop posting here