Prev: How can I insert rows BELOW, in Excel
Next: Excel error: "The path you entered, ---------- , is too long. "
From: Lise on 12 Apr 2010 19:24
Hi everyone

I have a spreadsheet where I have locked cells and password protected.
within this sheet though I have not locked a specific range of cells as they
are used in another sheet as source data.

Is there a way that I can allow these cells to still be copied for the
source data but not actually changed by other users??
--
Thanks as always

Lise
From: Dave Peterson on 12 Apr 2010 20:16
If you lock the cells and protect the worksheet, what happens when the user
tries to copy those cells?

Lise wrote:
>
> Hi everyone
>
> I have a spreadsheet where I have locked cells and password protected.
> within this sheet though I have not locked a specific range of cells as they
> are used in another sheet as source data.
>
> Is there a way that I can allow these cells to still be copied for the
> source data but not actually changed by other users??
> --
> Thanks as always
>
> Lise

--

Dave Peterson
From: Lise on 14 Apr 2010 21:05
Hi Dave

The only way the source data works is if I unlock a specific range ie data
in the row under Jan - Dec - the problem with this is that other users can
then edit those cells which I don't want if possible? thoughts?
--
Thanks as always

Lise


"Dave Peterson" wrote:

> If you lock the cells and protect the worksheet, what happens when the user
> tries to copy those cells?
>
> Lise wrote:
> >
> > Hi everyone
> >
> > I have a spreadsheet where I have locked cells and password protected.
> > within this sheet though I have not locked a specific range of cells as they
> > are used in another sheet as source data.
> >
> > Is there a way that I can allow these cells to still be copied for the
> > source data but not actually changed by other users??
> > --
> > Thanks as always
> >
> > Lise
>
> --
>
> Dave Peterson
> .
>
From: Dave Peterson on 14 Apr 2010 22:13
I guess I don't understand enough.

Why can't you lock that range?
What do you mean by source data and why can't those cells be locked?



Lise wrote:
>
> Hi Dave
>
> The only way the source data works is if I unlock a specific range ie data
> in the row under Jan - Dec - the problem with this is that other users can
> then edit those cells which I don't want if possible? thoughts?
> --
> Thanks as always
>
> Lise
>
> "Dave Peterson" wrote:
>
> > If you lock the cells and protect the worksheet, what happens when the user
> > tries to copy those cells?
> >
> > Lise wrote:
> > >
> > > Hi everyone
> > >
> > > I have a spreadsheet where I have locked cells and password protected.
> > > within this sheet though I have not locked a specific range of cells as they
> > > are used in another sheet as source data.
> > >
> > > Is there a way that I can allow these cells to still be copied for the
> > > source data but not actually changed by other users??
> > > --
> > > Thanks as always
> > >
> > > Lise
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
From: Lise on 15 Apr 2010 00:35
Hope this helps

Two sheets involved - one is a chart the other data (which is the sorce data
used in the chart)- If I lock the data sheet you can't update the chart
source data (which you need to do as I need to change the months each month)
the only way I have found this will work is by not locking the actual months
required in the data sheet - but this leaves them open for editing which I
don't want.
--
Thanks as always

Lise


"Dave Peterson" wrote:

> I guess I don't understand enough.
>
> Why can't you lock that range?
> What do you mean by source data and why can't those cells be locked?
>
>
>
> Lise wrote:
> >
> > Hi Dave
> >
> > The only way the source data works is if I unlock a specific range ie data
> > in the row under Jan - Dec - the problem with this is that other users can
> > then edit those cells which I don't want if possible? thoughts?
> > --
> > Thanks as always
> >
> > Lise
> >
> > "Dave Peterson" wrote:
> >
> > > If you lock the cells and protect the worksheet, what happens when the user
> > > tries to copy those cells?
> > >
> > > Lise wrote:
> > > >
> > > > Hi everyone
> > > >
> > > > I have a spreadsheet where I have locked cells and password protected.
> > > > within this sheet though I have not locked a specific range of cells as they
> > > > are used in another sheet as source data.
> > > >
> > > > Is there a way that I can allow these cells to still be copied for the
> > > > source data but not actually changed by other users??
> > > > --
> > > > Thanks as always
> > > >
> > > > Lise
> > >
> > > --
> > >
> > > Dave Peterson
> > > .
> > >
>
> --
>
> Dave Peterson
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: How can I insert rows BELOW, in Excel
Next: Excel error: "The path you entered, ---------- , is too long. "