Prev: Ziping excel 2007?
Next: sumif across multiple sheets in excel 2007 based on a conditio
From: Beverly on 12 May 2010 22:29
I'm using custom views and I have 19 tabs that reference each other - one tab
has a graph and a pie chart. As soon as I try to protect any of the
worksheets I cannot use custom views - a dialog box comes up "Some view
settings could not be applied". Is there a way around this? I'm using Excel
2003.

--
Thank you
Beverly
From: ozgrid.com on 12 May 2010 23:26
What "view setting" could not be applied?



--
Regards
Dave Hawley
www.ozgrid.com


"Beverly" <Beverly(a)discussions.microsoft.com> wrote in message
news:A03781A7-786A-46A5-85AE-99D711CDC903(a)microsoft.com...
> I'm using custom views and I have 19 tabs that reference each other - one
> tab
> has a graph and a pie chart. As soon as I try to protect any of the
> worksheets I cannot use custom views - a dialog box comes up "Some view
> settings could not be applied". Is there a way around this? I'm using
> Excel
> 2003.
>
> --
> Thank you
> Beverly

From: Beverly on 13 May 2010 00:22
That's all I get is the dialog box that states "some settings could not be
applied". After a lot of trial and error I figured out it was when 3 other
sheets were protected that I couldn't apply the custom view to the other
sheets.
--
Thank you
Beverly


"ozgrid.com" wrote:

> What "view setting" could not be applied?
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
>
>
> "Beverly" <Beverly(a)discussions.microsoft.com> wrote in message
> news:A03781A7-786A-46A5-85AE-99D711CDC903(a)microsoft.com...
> > I'm using custom views and I have 19 tabs that reference each other - one
> > tab
> > has a graph and a pie chart. As soon as I try to protect any of the
> > worksheets I cannot use custom views - a dialog box comes up "Some view
> > settings could not be applied". Is there a way around this? I'm using
> > Excel
> > 2003.
> >
> > --
> > Thank you
> > Beverly
>
> .
>
 | 
Pages: 1
Prev: Ziping excel 2007?
Next: sumif across multiple sheets in excel 2007 based on a conditio